Spring Cleaning of the SQL Server agent jobs

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

 

 

 

Expired subscription failed and has later been disabled

bild1

 

1. Create a new job step
Command
Select 1
or (– comment something out)

bild2

 

 

 

2. Change the step to report success

bild3

 

 

 

3. Change the job to start with the new step

bild4

 

 

 

4. Run the job

bild5

bild6

 

Now it looks better

bild7

 

 

 

5. Finish by removing the job step

 

 

This is obviously not a necessary measure, but if you want some orderliness it’s a way to fix it. A failed and disabled job could also make you miss it when it actually fails, “The Boy Who Cried Wolf” syndrome.