After SQL

Use this property to specify the SQL statement that is run once per job after any parallel processing occurs.

This property is available only if you set Before/After SQL to Yes.

You can type more than one statement in this property. Separate each statement with a semicolon (;). For server jobs, if you enable the Fail on error property, the job stops if an error occurs. For parallel jobs, the job does not stop if an error occurs.

To specify that this SQL statement is run once on each node or logical processor that can be a computer or a partition on a computer, use the After SQL (node) property instead of this property.

Click ellipses button to open a statement window in which to type your SQL statement. This button is available only when you click inside the property.

Valid values are determined by the specific database.