I have a SQL job. If the job fails / succeeds, I want to send the mail to user.
For this, I created an operator
under SQL Server Agent
and put down my email address in the E-mail name
text box under Notification Options
Then, on the Properties
of my created SQL job, under the Alerts
section, I created new
alert. Checked the Notify Operators
check box and selected the newly created Operator.
I think this is what we have to do to receive mail if the job fails/succeeds.
But I am not able to receive any mail. When I checked the Error Log, it showed me this error message, "Error, An attempt was made to send an email when no email session has been established"
I referred this http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/32a2c09a-156f-43b2-9076-b11ba9ccdafb/
link for the help but start/ stop/ restart of SQL Server Agent is of no help.
Can anybody help me to receive mail after the sql job completes???
Any help appreciated.