SQL Jobs monitoring tool

Question

Post reply

SQL Jobs monitoring tool

iRobot

Ten Centuries

Points: 1242
More actions
September 10, 2012 at 12:16 pm

#280991

We have a large number of jobs running on SQL DB servers. Is there a tool to find out what is actually running and what they all do?
Management want all this to be documented. We are using sql server 2008r2.
Any thoughts?

Viewing 8 posts - 1 through 7 (of 7 total)

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

ultimate sql Mr or Mrs. 500 Points: 575 More actions · Answer 1

This might answer your question

or this one

http://www.sqlservercentral.com/Forums/Topic1085386-391-1.aspx#bm1085485

Almost all database monitoring tools provide interface for Job monitor.

[font="Tahoma"]Fahim Ahmed[/font]
[font="Times New Roman"]Knowledge is a journey, not a destiny [/font]

iRobot Ten Centuries Points: 1242 More actions · Answer 2

Ahmed,

I am not a DBA and haven't actually used any of those tools. But I came across some great queries which will provide SQL Agent Jobs and schedules related information.

http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

If I could just set up some interface wouldn't it do the job?

What would be your input on this? Please advise.

BLOB EATER SSChampion Points: 14609 More actions · Answer 3

iRobot (9/11/2012)
Ahmed,
I am not a DBA and haven't actually used any of those tools. But I came across some great queries which will provide SQL Agent Jobs and schedules related information.
http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/
If I could just set up some interface wouldn't it do the job?
What would be your input on this? Please advise.

I have used queries similar to what you have posted but converted them to SSRS so we have a central point to view whats going on at a server level regarding agent jobs. Can get interesting and handy when needing to pivot of a certain day, drilling down on job X etc.

iRobot Ten Centuries Points: 1242 More actions · Answer 4

iRobot

Ten Centuries

Points: 1242

September 12, 2012 at 6:36 am

#1536684

That sounds great! Could you please post it?

Thanks

iRobot Ten Centuries Points: 1242 More actions · Answer 5

Is there a way to figure out which tables are affected by which jobs?

iRobot Ten Centuries Points: 1242 More actions · Answer 6

I cannot figure out which table to get information for the next scheduled Job.

Would it be dbo.sysschedules -active_start_date,active_start_time

OR

dbo.sysjobschedules- next_run_date,next_run_time?

Sodtke SSC Eights! Points: 982 More actions · Answer 7

iRobot (9/18/2012)
I cannot figure out which table to get information for the next scheduled Job.
Would it be dbo.sysschedules -active_start_date,active_start_time
OR
dbo.sysjobschedules- next_run_date,next_run_time?

Yes, next_run_date and next_run_time will give you what you are looking for. Be aware though that the time field is in Integer format, and won't have leading zeros, so you will have to pad the output if you are making any type of report.

Hope this helps.