The Data Integration Service can recover some workflows that are enabled for recovery. Workflow recovery is the completion of a workflow instance from the point of interruption.
A workflow can be interrupted in the following situations:
An error occurs.
You cancel the workflow instance.
You restart the Data Integration Service.
A Data Integration Service process shuts down unexpectedly.
If you abort the workflow instance, the instance is not recoverable.
The Data Integration Service performs workflow recovery based on the state of the workflow tasks, the values of the workflow variables and parameters during the interrupted workflow instance, and whether the recovery is manual or automatic.
When you configure the workflow options, you can configure the workflow for automatic recovery or manual recovery:
Automatic recovery
You can configure automatic recovery of workflow instances.
If you enable a workflow for automatic recovery, the Data Integration Service automatically recovers the workflow from the point of interruption when the Data Integration Service restarts.
If the Data Integration Service runs on a grid and the master service process fails over, all nodes retrieve object state information from the Model repository. The new master automatically recovers workflow instances that were running during the failover and that are configured for automatic recovery.
The Data Integration Service does not recover workflows that are not configured for automatic recovery. You can manually recover these workflows if they are enabled for recovery.
Additionally, the Data Integration Service does not recover any SQL data service, web service, mapping, profile, or preview job that was running during the failover. You must manually restart these jobs.
Manual recovery
If you configure manual recovery, you must manually restart the workflow and wait until after the Data Integration Service restarts, if necessary.