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-14 : 15:59:20
|
| What would the code to run a table called "efm_special_projects" to run daily? Also if the day is sunday, what would the code be to back up this table into the database "genarch" otherwise delete old table? how would i put that into code?Roger DeFour |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-03-15 : 00:56:22
|
quote:
Originally posted by Trininole
What would the code to run a table called "efm_special_projects" to run daily?
What you mean by this ?quote:
Also if the day is sunday, what would the code be to back up this table into the database "genarch" otherwise delete old table? how would i put that into code?Roger DeFour
Please show us what you tried ? |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-15 : 05:23:48
|
You need to use the SQL Server Agent to schedule stuff on sql server -> - LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
|
|
|
Stored procedure to run daily