Post reply

When did a job start and how long has it been running

  • April 13, 2012 at 7:56 am

    #272584

    IS there a way I can see what date and time a job started and how long it has been running for.

    ** Note this is for jobs that a still processing the first step - If a job is on step two it will have written to the history for the job, but until that point, I cant see what time a job started.

    Can anyone help?

  • April 13, 2012 at 11:48 am

    #1473385

    You can look in sys.dm_exec_sessions for running sessions. For Agent jobs the program_name column will look something like this where the binary string will be the id of your job:

    SQLAgent - TSQL JobStep (Job 0x2D70138D683A6E41ADBC0499389861A5 : Step 1)

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 13, 2012 at 2:56 pm

    #1473539

    exec sp_help_jobactivity @job_name = 'Your Job Name'

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

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