A "trigger" is only used when a record is Inserted, Update or Deleted - whereas a Scheduled Task is used for something that needs to run to a schedule - e.g. every minute.
You can create a procedure with the update and delete statement based on your condition. Create a Job which calls your procedure and then schedule the job with some interval of time.
hi how can i check all rows in the trigger for example i my table got Bit type column i need to check the column for all row if false remove that row how to do this
hi i created a table SysFTS with stime column(datetime) this is my trigger Create Trigger TestTrigger on SysFTS for update as Waitfor DELAY '00:00:59' update sysfts set stime = getDAte()
i run the update query so the trigger fires but inside the Trigger after 59 second again i update the Table the Trigger supposed to be fire again right but didn't fire wats wrong in my Trigger
A "trigger" is only used when a record is Inserted, Update or Deleted - whereas a Scheduled Task is used for something that needs to run to a schedule - e.g. every minute.
You can create a procedure with the update and delete statement based on your condition. Create a Job which calls your procedure and then schedule the job with some interval of time.
Sql Server Timer Trigger
Posted - 07/14/2010 : 05:08:31
