How to Restore an Agent Job that was Dropped

Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still there, but the other one – the important job – was gone.

Panic started knocking on your door! Oh, if only you had jobs in the source control or scripted out as a backup.

You take a deep breath and a sip of cold water