• Kevin,

    Very thorough explanation, thanks. Well, I have done SQL procs where I periodically have sent out emails to inform of progress. We use sp_send_dbmail here though. It usually involved a custom proc executed from the main one like:

    exec usp_send_progress_email 'whomever@mycompany.com'), 'Status of My Job - Step 2 finished'

    ...and if you needed to include data, then in your main proc maybe you could load some table, then do a query

    when you send the email by adding a 3rd param that you pass such as: 'select field1 'Hdr1', field2 'Hdr2' from mydatabase.dbo.tblMyJobStatus where convert(char(10),dtJobRun,101) = convert(char(10),getdate(),101)'

    the executed proc:

    Alter procedure usp_send_progress_email @emRecipient varchar(50), @emSubject varchar(100), @emQuery = varchar(500) = null

    AS

    exec sp_send_dbmail @emRecipient, @emSubject, @emQuery

    Would require dbmail set up if you don't have it already.

    For more: http://msdn2.microsoft.com/en-us/library/ms190307.aspx