Post reply

See overview of schedules

  • December 6, 2011 at 1:54 am

    #247323

    Is there a way to see an overview of all the schedules you have running so you don't set loads of jobs to run at one time??

  • December 6, 2011 at 2:30 am

    #1417162

    In MSDB there are sysjobs and sysjobschedules tables.

    I think there are others too. Search these names for examples of job schedule listings.

  • December 6, 2011 at 2:48 am

    #1417165

    As Tom said you can query sysschedules/sysjobschedules to list out all the schedules you are running the jobs on. In SSMS you can use Job Activity Monitor to see all job's status & schedules etc.

    You can use stored procedure sp_help_jobschedule also to return the schedule information for a job.

    Sujeet Singh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply