<div>
the other way is to write a stored proceudre and put an infinite loop with the wait for dealy function..<br />
the logic goes as below <br />
<br />
step 1: Create a SP<br />
step 2: create an end less loop<br />
step 3: inside the loop put your update statement<br />
step 4: put the wait for dealy statement inside the endless loop.<br />
<br />
Now execute the stored procedure.<br />
<br />
Drawbacks when compared to SQL Job:<br />
<br />
1) if the session is killed, in which the SP is running then the stored procedure will be stopped and you have to re-execute it again.
</div>


the other way is to write a stored proceudre and put an infinite loop with the wait for dealy function..
the logic goes as below

step 1: Create a SP
step 2: create an end less loop
step 3: inside the loop put your update statement
step 4: put the wait for dealy statement inside the endless loop.

Now execute the stored procedure.

Drawbacks when compared to SQL Job:

1) if the session is killed, in which the SP is running then the stored procedure will be stopped and you have to re-execute it again.

<div>
<div class="content wysiwyg-content">
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 . &nbsp;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<br />
<br />
Request expert's help in this regard at the earliest. <br />
<br />
<br />
DB is MS SQL 2008R2
</div>
</div>


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

Triggering an update event on table column after specific time duration

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.