Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    3

    Unanswered: Date Value Question trigger

    Hi,

    Currently have a table (SiteValues) that when updated inserts the a date/time into column called (ClDateTimeA).

    I have another table (CurrDate) with a current date column known as (CurrDate)

    I want to create a trigger that delete's the row in the table SiteValues whenever (ClDateTimeA) the row has gone over its specified date by 2 weeks.

    How may i accomplish this.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Sounds like you want a scheduled job rather than a trigger.
    Look at management/sql server agent/jobs in enterprise manager.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •