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

    http://msdn.microsoft.com/en-us/library/ms188025(SQL.90).aspx

    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