SQL 2000: find jobs by operator id

-- find jobs by operator id
select *
from msdb..sysjobs
where notify_email_operator_id = 31
   or notify_netsend_operator_id = 31
   or notify_page_operator_id = 31


select *
    from msdb..sysnotifications

select *
    from msdb..sysoperators
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s