Building and Using a One Time Job

Among the rich options we have for jobs is the ability to set a job to automatically delete itself. In this example we schedule a requested change to a table to run after hours, but that could just as easily be updates to "fix" data or to rebuild a troublesome index. It's a simple technique that you'll use a lot during your career.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Raman Thatikunta on 11/20/2009

The job was setup to run one time only and it was run once only. I'm not sure why it produced an error. Thanks for presenting these tidbits in short, to-the-point videos. Much appreciated.

Don Weigend on 11/20/2009

Auto deletion of the job is a cool feature. We tend to have a lot of one time only jobs hanging around so this feature will help with that. Great tip!

D151BB6B9F on 11/20/2009

The error message when run manually needed a little more explanation. Would there be an error if it had been run as scheduled, rather than manually? Errors always unnerve me.

Tonci on 11/20/2009

Extremely useful to know. Thank you.

nilanaksha on 11/25/2009

This would really be helpful in managing day-to-day activities.

Team FAB on 12/2/2009

I wanted to have a bit more explanation as to why the error occurred, it doesn't seem as if you would expect an error from what was done.

Andy Warren on 12/3/2009

Team - it's just a quirk of the UI as far as I can tell, it actually works the way it's supposed to other than the error:-)

A Alagu Ganesh on 2/10/2010

Good

C Arnold on 2/24/2010

I've been using jobs for many years, but never really noticed that checkbox. Pretty cool! Thanks!

Ramkumar Murugesan on 8/1/2011

Nice Feature to have