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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-02 : 08:05:10
|
| Prakash VSSS Ajjarapu writes "Hi,I'm using MS SQL Server2000 on Windows 2000 Advanced Server. My project needs a trigger thru which I can send mails to selected clients from database. The trigger needs to be fired when the server time touches 2:00am. Can someone help me how to fire with a hint on how to fire the trigger?ThanksPrakash VSSS Ajjarapu" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-02 : 08:12:29
|
this is not a job for a trigger  use scheduled job for this.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Time based trigger firing