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 |
|
wongz
Starting Member
6 Posts |
 Posted - 2003-06-04 : 22:06:35
|
| Hi,I am a student and i would like a professional opinion on my above senarios.I am trying to develop a reminder that uses SQL mail to send email to my user based on the server time.Thus i would like anyone here that have any idea or any URL that i an refer to as my reference.Thank you in advance.wong |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-04 : 22:19:46
|
| My first suggestion is to NOT use SQL Mail for something like that. It is not a full-blown email service and is not intended to do a lot of emailing. If you were sending emails based on database activities, like backups or other job completions, emailing reports based on data from the database, and such, then it makes sense, but without those features it's really not worth using for something like that. |
 |
|
|
wongz
Starting Member
6 Posts |
Posted - 2003-06-04 : 22:28:44
|
| Thank you very much for your reply,for the emailling i will switch to other alternative mailling system.But my problems is how to write an reminder that will auto matically fire based on the time that store in the table? I hope is there any possible way to do that in the SQL Server layer rather on my application layer. Thank you very much. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-04 : 22:32:28
|
| Well, why are you storing the time in a table in the database? If that's all that the database is for, it seems to be somewhat wasteful. It can be done more easily in the application layer, unless you have specific needs that require a database. Adding a database layer to an app simply to store a time value is overkill.Windows 2000 has a task scheduler that can run just about any task on any schedule you like. Since it's built into the operating system it's about as lightweight as you can get, and doesn't require much (or any) programming. |
|
|
|
wongz
Starting Member
6 Posts |
Posted - 2003-06-04 : 22:36:56
|
| Actaully i am trying to develop a schedule system.Something like a reminder for outlook usong asp.net and sql server 2000. I just want to send a reminder to my user base on the time that set by the user thus i wanted to do it in the sql end and it's automatically send and auto fire up based on the time in the table.wong |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-06-05 : 02:42:08
|
| Hi wongz!There is no way to do that realtime, using only the SQL package. However, you can schedule a job in SQLAgent to check the times once a minute, and take action (run a proc etc).Or you can build a realtime windows service if you need that kind of solution. |
|
|
|
|
|
|
|
|
send email based on certain time