• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to Enable or Disable All Jobs in SQL Server?

February 22, 2017

We display the result of the SELECT.

 

 Result looks like this:

 

 

 

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!

 

 

 

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon