What is equivalent of Sysjobschedules in 2005?

• Amit W

  Ten Centuries

  Points: 1048

  More actions

  August 9, 2007 at 10:33 pm

  #180268

   

  Hi All,

  I have a script which works well for SQL 2000. It references sysjobschedules in MSDB and columns like

  freq_type

  freq_interval

  freq_subday_type

  freq_subday_interval

  freq_relative_interval

  freq_recurrence_factor

  in it. Do we have any table corresponding to this in 2005? The script is failing because in 2005 the sysjobschedules only has columns

  schedule_id

  job_id

  next_run_date

  next_run_time

  Thanks in advance.

  -Amit

• Amit W

  Ten Centuries

  Points: 1048

  More actions

  August 10, 2007 at 1:02 am

  #725907

  Found the answer after digging a bit in BOL.

  There is a table named sysschedules which can be used and the relation between sysjobs, sysjobschedules and sysschedules is

  sysjobs.job_id = sysjobschedules.job_id

  and

  sysschedules.schedule_id = sysjobschedules.schedule_id

  -Amit