Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-05-17 : 23:21:25
|
| Hi Guys,I want to send E-mails automatically to 3 people on every monday night at 12. I want to write that query in sql server stored procedure. so that i can call this stored procedure from my application in VB.NET. I don't know how to write query to send E-mail on Every Monday night at 12. Could you guys help me with this. appreciate your help.Thanks, |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-17 : 23:25:19
|
| You can't write a query to do that. You can write one to send email. You can schedule the execution of that query with a scheduled job (SQL Server Agent), but the query just won't call itself every Monday at 12:00. That would be a job for a scheduler like the Agent or your application. Why don't you just have your app get the list of people from SQL Server and send the email on a scheduled basis? You could write a service for it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-18 : 03:25:02
|
| http://sqlteam.com/forums/topic.asp?TOPIC_ID=66265MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Automatically Send E-mail every Monday.