I have database table column which needs to updated after specific duration. One way of doing this is create a job and schedule it after the specific duration . is there any better way of doing this. To be specific can the same task be accomplished by a trigger which fires on the specified table column after specific duration
Request expert's help in this regard at the earliest.
DB is MS SQL 2008R2