Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wsilage
Yak Posting Veteran
82 Posts |
 Posted - 2015-01-07 : 14:17:16
|
| I was wondering if there is a query out there that can find all of the SP jobs that get sent out to a certain email address example 123@xyzcompany.comThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-07 : 14:28:26
|
| select jobs.name, steps.step_namefrom msdb.dbo.sysjobsteps stepsjoin msdb.dbo.sysjobs jobs on steps.job_id = jobs.job_idwhere command like '%your search criteria goes here%'Please note that you need to escape certain characters, such as the underscore.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Finding Recipients in Jobs