How can I Sende email notification Form Shaduled job in sql server 2008
Posted on 2011-09-14
I hope somebody can help in this
I need to receive email notification when my job tasks in sql server succeed or competed or failed
I did the following
1 - I configure my sql server 2008 to send email notification and I tested successfully
By creating profile and account.
2 - From SQL server surface area configuration manager I did enabling Database mail stored procedure
3 - Port 25 opened
4 - I run the following scripts
sp_CONFIGURE 'show advanced', 1
sp_CONFIGURE 'Database Mail XPs', 1
When I test by running the following script I receive the email .
EXEC sp_send_dbmail @profile_name='Profile1',
@body='This is the body of the test message.
Congrates Database Mail Received By you Successfully.'
5- I create operator … MAK
6 - I create backup task and I configure it to send email notification to operator MAK
My Problem That I did not receive the email when job succeed or competed or failed
I need help please