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 |
|
Jacques
Starting Member
5 Posts |
 Posted - 2007-06-07 : 14:06:24
|
| I was wondering if there is a way to schedule job through triggers. Suppose I want to create a trigger which executes some command every monday at noon. Is it possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-07 : 14:10:53
|
| This is not the purpose of triggers. Just add your code to a job step and schedule it to run when you want it to.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-07 : 14:11:42
|
| You should be scheduling a JOB to run every monday to execute the command. Not a trigger.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Jacques
Starting Member
5 Posts |
Posted - 2007-06-07 : 14:45:02
|
| Thanks guys. |
|
|
|
|
|
|
Scheduling jobs using triggers