top of page

How to Enable or Disable All Jobs in SQL Server?

We display the result of the SELECT.

Result looks like this:

Result Enable or Disable All Jobs

For change please use system stored procedure sp_update_job. For more details - MSDN

For example:

Please!!! Don't use UPDATE for table sysjobs like below!!!

Thank you for reading!


bottom of page