• You can find this in the job history table.

    SELECT j.name,

    jh.run_date,

    jh.run_time,

    SUBSTRING(jh.message, CHARINDEX('.', jh.message) + 3, CHARINDEX('.', jh.message, CHARINDEX('.', jh.message) + 1) - CHARINDEX('.', jh.message) - 3) AS MiddleMessage

    FROM msdb..sysjobhistory jh

    JOINmsdb..sysjobs j

    ON jh.job_id = j.job_id

    WHEREjh.step_id = 0

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]