We help IT Professionals succeed at work.

Where do I find what time a job is scheduled to run?

I need to run a query to tell me when all my jobs are scheduled to run.  So I am just need to know what table would that information be in.

thanks,

Gabicus
Comment
Watch Question

Senior Developer Analyst
Commented:
use msdb
go

select *
from      sysjobschedules
Richard ComitoDirector of IT

Author

Commented:
gohord,

Thank you for the reply.  This is just what I needed.

Best,

Gabicus

Explore More ContentExplore courses, solutions, and other research materials related to this topic.