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 |
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2008-09-17 : 08:47:19
|
| I have an .net app that sends emails out to the client. They want to send the emails out at a certain time. Can I do this with sql 2005DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2008-09-17 : 09:03:54
|
| You can use SQL Server Agent to schedule the task for a certain time.Can send emails using msdb..sp_send_dbmail or a batch file calling your application. |
 |
|
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
Posted - 2008-09-17 : 10:08:56
|
| I get this error in 2005Could not find stored procedure 'sp_send_dbmail'DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 10:11:04
|
| Because you are not using MSDB database. |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2008-09-17 : 10:12:09
|
| Look it up in BOL.The procedure is in the MSDB database. |
|
|
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
Posted - 2008-09-17 : 10:44:09
|
| Ok. I have it running. Now I have a table with the following fields "recipient, subject, body" the table name is emailsToSend. I want to set up a job to run that will go threw that table to see if there are and records and send them. Is this possible? If so, how would I do this? You guys are great. It would take me a looong time to figure this out.DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 10:46:59
|
| Goto SQL Server Agent- jobs-Setup. |
|
|
|
|
|
|
Is this possible