Disable an SQL Server Agent job on failure
Sometimes when your SQL Server Agent jobs fail you don’t want them to run again, It’s a simple extra step to disable the job. Firstly create a new job step to disable the job, perhaps called DISABLE JOB STEP and