• This happens if your job has multiple steps say Step1 and Step2.

    For each step, you need to specify the SQL Server agent what to do in case of success or failure of that step.

    In this case , suppose that

    Step 1 : Delete Old Backups

    Step 2 : Take Backup

    Then for Step1 and Step2 you need to specify some thing like this

    Step1 : On Success ---> Goto Step 2

    On Failure ---> Quit the job reporting failure or Goto Step 2

    Step2 : On Success ---> Quit the job reporting success.

    On Failure ---> Quit the job reporting failure.

    Thank You,

    Best Regards,

    SQLBuddy