An application developer would like for an entire record to be automatically deleted after a datetime field has existed for exactly a year within the database. As a novice DBA, I'm not sure how best to approach this task. Please advise. Thanks.
You could create a job to be run every day to check for the condition, or if inserts, updates or deletes are common in the db, create a trigger to check the condition.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply