I am a Production DBA, and my team supports several thousands instances of MS SQL.
Frequently, we get a request to grant temporary access to server XYZ, either sysadmin or DBO to certain databases.
It has become a challenge to remember to go back and remove the privileges, so I devised a little script to take care of it.
It's nothing really new, it is just a job with a self deleting feature, where I add a step to delete the job.
What do you need to do?
Give the Job a name, a schedule, and the TSQL command that you want to run. That simple!
After the job runs, it will self-destruct.
Since the Job is deleting it self before it finish executing, there will be an entry on your SQL Agent log that would say:
 Job SelfDeletingJob was deleted while it was executing: the outcome was (Unknown)