top of page
  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon
Search

How to Enable or Disable All Jobs in SQL Server?

  • Writer: Filip Holub
    Filip Holub
  • Feb 22, 2017
  • 1 min read

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!

 
 
 

Comments


RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

bottom of page