Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Jobs monitoring tool Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 12:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:12 AM
Points: 36, Visits: 109
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?
Post #1356945
Posted Monday, September 10, 2012 7:31 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 10, 2014 10:49 PM
Points: 194, Visits: 194
This might answer your question

[url=http://www.sqlservercentral.com/Forums/Topic1292959-148-1.aspx#bm1293762][/url]

or this one

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

Almost all database monitoring tools provide interface for Job monitor.




Fahim Ahmed
Knowledge is a journey, not a destiny
Post #1357085
Posted Tuesday, September 11, 2012 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:12 AM
Points: 36, Visits: 109
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.
Post #1357368
Posted Wednesday, September 12, 2012 1:44 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 8:12 AM
Points: 173, Visits: 559
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.


-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship
Post #1357823
Posted Wednesday, September 12, 2012 6:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:12 AM
Points: 36, Visits: 109
That sounds great! Could you please post it?
Thanks
Post #1357941
Posted Friday, September 14, 2012 1:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:12 AM
Points: 36, Visits: 109
Is there a way to figure out which tables are affected by which jobs?
Post #1359587
Posted Tuesday, September 18, 2012 4:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:12 AM
Points: 36, Visits: 109
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?
Post #1361050
Posted Wednesday, September 19, 2012 6:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:52 PM
Points: 27, Visits: 248
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.
Post #1361276
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse