VastSQL
SSC-Dedicated
Points: 36097
More actions
June 25, 2014 at 12:53 am
#308489
Hi Experts,
How can i find what all jobs have mentioned an email address inside the TSQL used for that job?
Thanks in Advance
Koen Verbeeck
SSC Guru
Points: 259115
June 25, 2014 at 12:59 am
#1724526
The job steps are stored in the [msdb].[dbo].[sysjobsteps] table.
You can filter on the subsystem (only TSQL) and then search inside the command for email addresses.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2014 at 1:28 am
#1724531
Thanks Koen.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply