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)