• Rob

    Please run these two queries and post the results:

    SELECT

    s.step_id

    ,s.on_success_action

    ,s.on_success_step_id

    ,s.on_fail_action

    ,s.on_fail_step_id

    FROM

    msdb..sysjobs j

    JOIN

    msdb..sysjobsteps s

    ON

    j.job_id = s.job_id

    WHERE

    j.name = '<Job_Name>'

    SELECT TOP (15)

    h.step_id

    ,h.run_date

    ,h.run_time

    ,h.run_status

    FROM

    msdb..sysjobs j

    JOIN

    msdb..sysjobhistory h

    ON

    j.job_id = h.job_id

    WHERE

    j.name = '<Job_Name>'

    ORDER BY

    run_date DESC

    ,run_time DESC

    John