You can automate changes in state by scripting a state’s OnTimeout event to evaluate a condition, and when that condition is met, perform an action—such as a state change or e-mail notification.
For example, in your Issue Tracking solution, you might want the state for issues that are in the Activated state for more than two weeks to be updated to the Escalated state automatically.
The SQL Server Agent monitors the OnTimeout event. The agent runs stored procedures on the server to execute the time-out events based on a predefined schedule. You can set up the agent to run hourly, daily, or weekly—based on the requirements of your team solution. Because the OnTimeout event relies on stored procedures on the server, these actions are not executed while a solution is offline.
To specify a time-out action