OnExpire Events

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

You can automate events by scripting an OnExpire event to evaluate a condition and, when that condition is met, perform an action — such as a transition or e-mail notification.

The SQL Server Agent monitors the OnExpire event. The agent runs stored procedures on the server to execute 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 workflow application.

After you add the Expiry transition to your workflow process, an administrator can set the SQL Server Agent time-out information in the Workflow Manager for SQL Server. Open the Workflow Manager and, on the Tools menu, click WorkflowTimeout Job.

See Also

Automating Changes and Events | When to Use Which Event | Script Procedure Names | Control of Row Changes Based on State | OnEnter and OnExit Events | Adding Transition Events