I have scenario where i need to run my store procedure on specific time frame ? For instance i have a field in my table1 called count.
- If the value of count is 1 for a specific row in table then rightaway the specific row will move to another table2.
- If the value of count is 2 for a specific row in table1 then the specific row will move to another table2 after 10 min not right away.
i think for this some job should continous run in background, I have store procedure and i want to run that store procedure as background job in MSSQL continous. How can we do that or any other approch? please suggest me.
View Complete Post