T-SQL to check what backup jobs are setup

• Joe O'Brien

  SSC Enthusiast

  Points: 104

  More actions

  January 9, 2009 at 7:49 am

  #198116

  Hi,

  does any body have a piece of T-SQL that will run on 2005 to tell me what jobs are setup on my sql server and how often the job is set to run?

  Thanks in Advance

• SQLRockstar

  SSCertifiable

  Points: 6617

  More actions

  January 9, 2009 at 8:01 am

  #924193

  hi joe. this snippet should help get you started.

  select sj.name, sjs.next_run_date, sjs.next_run_time

  from msdb..sysjobs sj

  inner join msdb..sysjobschedules sjs on sj.job_id = sjs.job_id

  inner join msdb..sysschedules ss on ss.schedule_id = sjs.schedule_id

  order by sj.name

  ----------------------
  https://thomaslarock.com

• Joe O'Brien

  SSC Enthusiast

  Points: 104

  More actions

  January 9, 2009 at 9:29 am

  #924317

  Hi Thomas,

  thank you very much.

  Joe