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-10-10 : 07:42:18
|
| Imran writes "I want to execute a Stored Procedure automatically on the last date of every month at 12:00 am. Would you please help me how can i do that in SQL Server.I think we can do it by using Task Scheduling in SQL Server. But I don't know how can do it. Please help me regarding it.ThanksImran Ashraf" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-10 : 15:26:58
|
| You can schedule a Job to run on the last date of every month and the Job Step can be to execute a Stored Procedure. You'll find more info about Jobs in SQL Server Books Online, or under the Management/SQL Agent tree in Enterprise Manager.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
Task Scheduling in SQL Server 2000 at specific time