April 28, 2009 at 12:04 am
I wanted to create a procedure which automatically sends email to people on their birthdays.
The procedure has to be scheduled in a windows 2000 server.
I am using sql server 2000. Could anyone suggest me how to do this?
The code should not ask for any inputs during runtime.
April 28, 2009 at 6:52 am
This is possibly not the best solution, but it will work:
1. Get the necessary information (Name, email address) of the people who have birthday that day.
2. Loop through and send using xp_sendmail or even better go get xp_smtp_sendmail and use that.
As part of step 2 you may need to do some replacing in the body of the email if you want to insert the person's name into the email.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 28, 2009 at 7:44 am
Please post int he appropriate forum. There are forums for 2000 questions. Moving this thread.
You would need to use SQL Agent to schedule this as well.
If you read up on this and make a try and still have specific questions, we are happy to help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply