You could use the sp_add_job to create a job which deletes itself after running and then execute it using sp_start_job.