Sql Server Timer Trigger - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Sql Server Timer Trigger

Author

Topic

sivakl_2001
Starting Member

4 Posts

Posted - 2010-07-14 : 05:08:31

hi i need to check a table(all rows) 1 mins once got update or not if not i need to remove the row
how to achive it

Kristen
Test

22859 Posts

Posted - 2010-07-14 : 05:18:12

Scheduled task?

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.

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-07-14 : 05:48:33

As per my assumption,

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 Programmers and Consultants
http://www.sql-programmers.com/

sivakl_2001
Starting Member

4 Posts

Posted - 2010-07-14 : 06:05:53

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

sivakl_2001
Starting Member

4 Posts

Posted - 2010-07-14 : 06:44:14

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

Kristen
Test

22859 Posts

Posted - 2010-07-14 : 07:01:31

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.

sivakl_2001
Starting Member

4 Posts

Posted - 2010-07-14 : 21:04:21

quote:
Originally posted by sql-programmers

As per my assumption,

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 Programmers and Consultants
http://www.sql-programmers.com/

can u tell me how to create simple job and how to schedule it

Kristen
Test

22859 Posts

Posted - 2010-07-15 : 02:01:59

In SSMS under the Server open up SQL Server Agent, right click JOBS and select NEW JOB.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources