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 |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2006-11-27 : 03:48:30
|
| Hi I Have a table "VehicleTrack" and want to write a Trigger which delete all rows of "VehicleTrack" Table at 7 AM Daily. means i want to perform Trigger action at a particular fix Time. How can I do.Ranjeet Kumar Singh |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-27 : 03:50:07
|
| Write a STORED PROCEDURE instead and connect that SP to a JOB that runs at the schedule you want.Peter LarssonHelsingborg, Sweden |
 |
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2006-11-27 : 03:56:10
|
| Ok I am Trying ThanksRanjeet Kumar Singh |
|
|
|
|
|
|
Fire a trigger at a Fix Time