Difference between running time of a JOB RRS feed

  • Question

  • Hi,
    I would like to know difference running time between a JOB.
    Example: in my sql server istance got many JOB...
    I would like know difference < 50% of job runnning respect precedent running...

    Someone can give some piece of code for start with my
    Thursday, August 21, 2008 8:23 AM

All replies

  • Hello,


    Please, could you have a look on this link ?

    you have an example of the the query to do to retrieve all the informations about all the jobs with a specific name

    The probleme is that you have to treat the data you get with the query ( run_duration is the duration of a job as integer with a special format HHMMSS so you have to calculate in seconds )

    you will have some work to do to treat the run_date and run_time fields to find the last and previous job


    Don't hesitate to post again for more explanations or help


    Thursday, August 21, 2008 8:51 AM