It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script below is useful when you have dozens or hundreds of jobs. It will help you you to avoid doing this work manually.

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.Use test database in a simple recovery mode. Create two tables and fill them by random data.