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 |
|
deswar
Starting Member
1 Post |
 Posted - 2010-02-10 : 00:58:18
|
| Is there a way to schedule to call a stored procedure which contains delete statements. Schedule task should be part of SQL server 2005. I am not looking for Windows scheduler/osql to call SQL stored procedure. I am wondering if something available as part of SQL itself. Or Do you suggest any other alternative. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-02-10 : 01:02:10
|
| Try Jobs of sql server.In jobs you can call the procedure for deleting the data. |
 |
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-10 : 01:58:07
|
"Try Jobs of sql server.In jobs you can call the procedure for deleting the data"But not available if you are using SQL Express - hence the work-around link above (which is a huge bodge IMHO  ) |
|
|
|
|
|
|
Scheduled stored proc call to delete records