|
Home > Archive > MS SQL Server New Users > April 2005 > email notifications from SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
email notifications from SQL
|
|
| Darren C. Haby 2005-04-12, 11:25 am |
| Hello Everyone,
I am attempting to learn how to use the email facilities within SQL
server. I have MSSQL running on Win2K3 server with an Outlook 2003 mail
client. I set up a simple job which backs up my databases on a set
schedule. This part is working fine. What is not working is the email
notification when the job completes. What I have noticed is that if I stop
the SQL server agent, start outlook, hit send/receive, close outlook and
restart the agent, the mail that I was expecting finally arrives. What have
I missed or failed to do?
thanks in advance,
Darren
| |
| Steve Thompson 2005-04-12, 1:23 pm |
| "Darren C. Haby" <darren.haby@swri.org> wrote in message
news:OuDXh33PFHA.2136@TK2MSFTNGP14.phx.gbl...
> I am attempting to learn how to use the email facilities within SQL
> server. I have MSSQL running on Win2K3 server with an Outlook 2003 mail
> client. I set up a simple job which backs up my databases on a set
> schedule. This part is working fine. What is not working is the email
> notification when the job completes. What I have noticed is that if I
stop
> the SQL server agent, start outlook, hit send/receive, close outlook and
> restart the agent, the mail that I was expecting finally arrives. What
have
> I missed or failed to do?
It could be a number of things, you may want to follow the steps in this
checklist:
HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/defaul...kb;en-us;321183
Steve
|
|
|
|
|