Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Timothy A Wiseman,
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)
How to track the Errors which occurs while a store procedure is executed in SQL Server 2000
Stored Procuders which has multiple execution plans
Error occuring while executing a SP which has calls to another server through linked servers
Trying to execute two SSIS packages simultaneously which have SQL Server Transfer Objects tasks in t...
how to retify error 5004 to use alter database, the database must be in a writable state in which a ...