SQL Agent

• How to stop the SQL Scheduler with T-SQL

  Dec 11, 2018

  A user had a unique issue where their system would have dynamically changing job names and schedules, but they need to disable and re-enable them during maintenance. Obviously, this is a huge headache.

  I made a recommendation that they should ultimately create a list of currently enabled jobs that had a schedule using a system query.

  SELECT *
  FROM MSDB.dbo.sysschedules ss
       INNER JOIN msdb.dbo.sysjobschedules jss 
  	 ON jss.schedule_id = ss.schedule_id
  WHERE ss.enabled = 1;
  

  The code above returns all schedules that are paired to a job that are enabled. The enabled = 1 flag and the inner join to the sysjobschedules table are what dictate those filters.