How to Enable or Disable All Jobs in SQL Server?
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!
Commentaires