1

Possible Duplicate:
Get a list of SQL Server Agent Jobs

is there a way to query the job schedule DB, and list out the jobs names, their schedules, frequency, and filter them, such that if I need can see which jobs run between 5AM -11PM everyday.

Community
  • 1
user280868
  • 11
  • 2

1 Answers1

1

Check out the SQL Server Agent tables. Specifically SysJobs for the actual jobs and then SysJobHistory for dates and times.

Wesley
  • 32,690
  • 9
  • 82
  • 117