How to time out a record? Triggers??

[suhash]

Hi All,

I need to time out a record in a DB. Can I do this via a trigger? Is there anyway to trigger a method every minute or for a give period?

Thanks in advance..

Mal.,

 

[stevexff]

When you say 'time out' do you mean 'expire'? As in 'this record is valid until a certain datetime'?

 

[suhash]

Yep. that is what I mean. I have a datetime field in a record. I need to refresh the records every 2 minutes. Can this be done?

Mal.

 

[mrdenny]

You would need to do this via a job.

Triggers are only fired when data is inserted, update or deleted. The have something run after that requires that something start the script. This is why Jobs exist in the SQL Server Agent.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[suhash]

Hi again,

Thanks for the info. Could you direct me to any resources on the web to learn about this please?

Thanks.

 

[mrdenny]

Books OnLine has tons of info about Jobs. It's under Start > Programs > Microsoft SQL Server

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)