|
Home > Archive > MS SQL Server > October 2006 > Need help to get automated emails
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 |
Need help to get automated emails
|
|
|
| I would like to send automated email alerts from my SQL server 2000
directly to my email with/without using Outlook. I am running on
Windows 2000 OS and I would like to get emails to alert me for example
when a contract is due to expire within a month or when an employee has
been employeed for more than 20 days etc...Can this be done?And if yes,
does anyone have any suggestions how to go about it step by step?Any
comments will be very appreciated as I am quite new to SQL server.
Thank you very much for you time!
| |
| Paul Ibison 2006-10-24, 6:38 pm |
| As you are using SQL Server 2000, to avoid a MAPI profile you'll need a SMTP
client. Please have a look at http://www.sqldev.net/xp/xpsmtp.htm for a free
one. Unfortunately it doesn't accept a query as a parameter so you'll need
to use a DTS package of BCP to get the data out of SQL Server into a file
and have that file as an attachment ie there's a fair bit of work involved.
If you can have a MAPI client, then using an Outlook profile on the SQL
Server box will bring into play xp_sendmail which has an @query parameter to
avoid the extra steps mentioned above. For more details on setting up mail
integration, please have a look at BOL and this article:
http://support.microsoft.com/kb/263556. At the bottom of the article there's
some links to show troubleshooting articles which are really helpful.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|
|
|
|
|