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 - 2002-03-06 : 08:36:50
|
| Neha writes "Hii..I have to transfer the data in one master table to another back up table on the 1st of every month.How do i do this?Please do help me.Regards,Neha" |
|
|
Jay99
468 Posts |
Posted - 2002-03-06 : 09:32:49
|
| ...with a scheduled jobA trigger requires some DML on the object (INSERT,UPDATE,DELETE); a trigger can't be directly scheduled. A job can be scheduled to run and can either execute some t-sql directly, fire off a dts package, even run a command line script.Jay |
 |
|
|
|
|
|
Trigger or Procedure