Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- msdb.dbo.SysJobs
- msdb.dbo.SysJobSteps
- UPDATE SJS SET
- Command = REPLACE(Command, 'EmailAddress&TestDomain.Com', '')
- FROM msdb.dbo.SysJobs SJ
- INNER JOIN msdb.dbo.SysJobSteps SJS
- ON SJS.Job_Id = SJ.Job_Id
- WHERE SJ.Originating_server = ..... -- Your server here
- AND SJS.Command LIKE '%[email protected]%'
Add Comment
Please, Sign In to add comment