April 29, 2015 at 3:27 pm
I'm new to SQL Server and I was wondering if anyone can help me with a query for SQL jobs.
I have hundreds of scheduled jobs (various times and days) and although I could look at each one individually, I was hoping there may be a system table or view I could query to get the job name and the time/day that it runs i.e. schedule.
I am trying to find a open window where I can do maintenance but it seems like jobs run almost 24/7 and if I could see the schedule at a glance, it would help a great deal.
Any suggestions are greatly appreciated.
Thank you
Terry
April 30, 2015 at 2:01 am
Daft question from me, maybe, but is the main Job Activity Window not sufficient?
It shows all the jobs, you can order them in a variety of ways, and it shows the times the jobs last ran and will next run.
Apologies if this is not suitable - just a very simple way to do it without resorting to system views and so on.
April 30, 2015 at 11:29 am
What about something like posted here
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/
May 1, 2015 at 7:08 am
sqljobvis is a really good free tool that gives you a graphical view of jobs and their running times on the sql server. worth a look.
May 7, 2015 at 4:11 pm
Awesome!
Thank you very much!
Terry
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply