create procedure sys.sp_help_log_shipping_alert_job
as
begin
    set nocount on
    declare @retcode int
    
    -- security check
    
    exec @retcode = sys.sp_MSlogshippingsysadmincheck
    if (@retcode != 0 or @@error != 0)
        return 1
    
    -- must be invoked from master db
    
    if (db_name() != N'master')
    begin
        raiserror(5001, 16,-1)
        return 1
    end
    
    -- return resultset
    
    select alert_job_id from msdb.dbo.log_shipping_monitor_alert
    
    -- all done
    
    return 0
end