Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: T-SQL statement to return SQL Job Last Run Date

    This returns runtime information:
    SELECT
        CAST(STR(h.run_date, 8, 0) AS DATE) AS StartDate
    ,   SUBSTRING(CAST(CAST(CAST(STR(h.run_date, 8, 0) AS DATETIME)
                  + CAST(STUFF(STUFF(RIGHT('000000'
                                           + CAST (h.run_time AS VARCHAR(6)), 6),
                                     5,...

Viewing post 1 (of 1 total)