As a DBA sometimes we get request for add/update/delete of DL’s – Distribution Lists (email groups) across all jobs on a SQL Server Instances. If the frequency of such request is very frequent then it’s better to write a script and run it on requests by simply modifying the email addresses.Here is how we will do this:We will take help of 2 tables msdb.dbo.sysjobsteps and msdb.dbo.sysjobstepsQuery to retrive the list of jobs along with steps which satisfies the condition to search for an email (Simply update...
Subscribe to:
Posts (Atom)
Posts
