Home Forums SQL Server 2008 T-SQL (SS2K8) How to usdate records after some time periode of its insretion in table. RE: How to usdate records after some time periode of its insretion in table.

  • The only way that I can think of is to have an SQL Agent Job running on a schedule that updates the record that have expired. However unles you are running this every minute there will be a latency based on the schedule where some rows will not be expired until for the duration of the latency, so on a 10 minute schedule then you will have rows that may not expire for <expire duration> + Schedule, depending on when they were due to expire.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices