sp_update_job for all jobs.

This script will generate a sp_update_job statement for every job on the server. In order to use it, populate the appropriate paramaters in the "Populate the Variables" section and execute the script. If testing is set to 1, it will generate the appropriate commands, but display instead of executing them. If testing is set to 0, it will execute the commands

This may be useful in cases such as:1. A server which has never had a configured operator needs to be configured with an operator and on failure notifications need to be set for every single job. (This happens to be why it was written)2. Paging ability is added to a server which did not have it before 3. A new policy is created which specifies that all jobs will be owned by a single account, such as a designated service account.4. All jobs need to be temporarily disabled without actually turning the agent entirely off (or reenabled when they are all off)

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.