Post reply

Job

  • October 4, 2011 at 7:59 am

    #258479

    Hi,

    How can I check how long a SQL agent job took to run?

    Thanks

  • October 4, 2011 at 8:20 am

    #1390160

    That can be found in the msdb..sysjobhistory table. Check the run_duration column.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • October 4, 2011 at 8:22 am

    #1390162

    Or in SSMS, right click the job, view job history.

    There's a column named "duration".

    -- Gianluca Sartori

Viewing 3 posts - 1 through 2 (of 2 total)

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