Post reply

SQL Jobs monitoring tool

  • 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?

  • September 10, 2012 at 7:31 pm

    #1535979

    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]

  • September 11, 2012 at 6:48 am

    #1536199

    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.

  • September 12, 2012 at 1:44 am

    #1536587

    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.

  • September 12, 2012 at 6:36 am

    #1536684

    That sounds great! Could you please post it?

    Thanks

  • September 14, 2012 at 1:04 pm

    #1538098

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

  • September 18, 2012 at 4:11 pm

    #1539319

    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?

  • September 19, 2012 at 6:13 am

    #1539501

    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.

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

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