Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: SQL Job History Information

    This should give you what you are looking for. Added status column also.

    SELECT

    jobs.name AS 'Job Name'

    ,step_id AS 'Step No'

    ,step_name AS 'Step Name'

    ,StartTime AS 'Start Time'

    ,DATEADD(SECOND,

    DATEPART(HOUR,Duration) * 3600 +

    DATEPART(MINUTE,Duration) *...

Viewing post 1 (of 1 total)