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 - 2001-12-21 : 09:35:21
|
| Vinod writes "How to trigger a stored procedure at the change of date in the sql server every midnight ??A procedure needs to check the sql server date and do some operations on the database.This should happen at 12:00 midnight." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-21 : 09:51:20
|
| Refer to Books Online under "jobs". You can create a job that executes your stored procedure, and schedule it to run at midnight, or any other time, at any interval you like. |
 |
|
|
|
|
|
Trigger an automatic Stored Procedure