finding start times of all SQL Agent Scheduled jobs

  • Hi,

    How would I go about determining the start times of all the SQL Server agent jobs on a particular server - is this easily accessible from the system tables.

    The angle i'm coming from is I want to add a new job and schedule but i want to do a quick check to ensure it's not going to clash with other jobs.

    cheers

  • You could query the sysjobschedules table in msdb which contains the next run date and time for all jobs. Something like this would get the job names also:

    select name, next_run_date, next_run_time

    from dbo.sysjobschedules s join dbo.sysjobs j on s.job_id = j.job_id

    Greg

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

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