在下面的示例中,收到一条消息;如果该消息以前传送过但未收到,则将消息 ID 输出到数据库服务器消息窗口:
begin
declare @msgid varchar(128);
declare @redelivered bit;
set @msgid = ml_qa_getmessage( 'myaddress' );
set @redelivered = ml_qa_getredelivered( @msgid );
if @redelivered = 1 then
message 'message with message ID ' || @msgid || ' has been redelivered';
end if;
commit;
end