InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 10:35:25 GMT20http://www.sqlservercentral.com/Forums/Topic422114-9-1.aspxArun,Has this helped?Thu, 15 Nov 2007 04:18:03 GMTEvilPostIThttp://www.sqlservercentral.com/Forums/Topic422114-9-1.aspxThe syntax for sp_add_job has a parameter called @delete_level. If you use this you can set the job to delete itself on completion (wether it is successful or not).You will need to look at sp_add_job,sp_add_jobstep & sp_start_job. (all in msdb)Quickest and easiest way to work all this out is to run sql profiler filtered by your username and create a job in enterprise manager. It will give you all the code you need. Job explore the options a little more to make sure your getting everything you want.Wed, 14 Nov 2007 15:32:30 GMTEvilPostIThttp://www.sqlservercentral.com/Forums/Topic422114-9-1.aspx"Create a job which deletes itself..."???!Explain.Wed, 14 Nov 2007 11:20:00 GMTArun T Jayapalhttp://www.sqlservercentral.com/Forums/Topic422114-9-1.aspxYou could use the sp_add_job to create a job which deletes itself after running and then execute it using sp_start_job.Wed, 14 Nov 2007 09:34:15 GMTEvilPostIThttp://www.sqlservercentral.com/Forums/Topic422114-9-1.aspxNo. You can only do this by having a job that runs (say every 5 minutes) to send the emails or execute other batch proceses.JezWed, 14 Nov 2007 09:22:21 GMTJez-448386http://www.sqlservercentral.com/Forums/Topic422114-9-1.aspxSay I have a procedure inside which I have the task of sending out emails...this may be another procedure or a batch of statements. Can I run this separately without my main batch processing not waiting or blocking for this task?Wed, 14 Nov 2007 08:09:54 GMTArun T Jayapal