InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:39:56 GMT20http://www.sqlservercentral.com/Forums/Topic1284614-92-1.aspxAdd a step into the job which uses WAITFOR TIME command to delay the sending of the mail. Then execute a msdb.dbo.sp_send_dbmail command with the mail you want to send.I would do two, one for success one for failure, then set the main job step to go to the right mail step depending on its outcome.SoStep1 - Run my procedure, on success go to step2, on failure go to step3Step2 - WAITFOR TIME '07:30' send success mail, on success quit reporting success, on failure quit reporting failureStep3 - WAITFOR TIME '07:30' send failure email, on success quit reporting failure, on failure quit reporting failureThu, 03 Jan 2013 05:54:47 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1284614-92-1.aspxYou can set some alert through an utility like after the successful completion of job you will receive a mail Use some monitoring software like thishttp://www.windowseventlogmonitor.com/Thu, 03 Jan 2013 05:49:57 GMTpeterdru401http://www.sqlservercentral.com/Forums/Topic1284614-92-1.aspxHello , Can you suggest me how to Receive a mail notification, not as soon as job completes but at a particular time after the job completion. In the job setup window, I just have an option in notifications as ' when job succeeds'. I want to get notified in the morning after job succeeds (job runs at night). May be I was thinking that I can use jobhistory tables (job_status column) and write a script such that if status is success, notify operator at particular time. Any suggestions would be appreciated.Mon, 16 Apr 2012 18:20:14 GMTsairam6819