Add 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.
Step1 - Run my procedure, on success go to step2, on failure go to step3
Step2 - WAITFOR TIME '07:30' send success mail, on success quit reporting success, on failure quit reporting failure
Step3 - WAITFOR TIME '07:30' send failure email, on success quit reporting failure, on failure quit reporting failure
How to post data/code for the best help - Jeff Moden[/url]
Need a string splitter, try this - Jeff Moden[/url]
How to post performance problems - Gail Shaw[/url]
Managing Transaction Logs - Gail Shaw[/url]
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]