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 |
|
Trininole
Yak Posting Veteran
83 Posts |
 Posted - 2011-03-01 : 16:22:46
|
| what line of code i use to modify a stored procedure with the name for example "efm_special_projects to run daily.if the day is sunday, how i do back it up to the database "genarch" but if it is not sunday, then delete. what line of code i use for that?Roger DeFour |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2011-03-02 : 05:47:23
|
| To schedule a stored procedure to run daily, have a look at SQL Server Agent or any other scheduling tool. |
 |
|
|
|
|
|
creating/modifying a stored procedure