Create a Stored Procedure Action

Use this action to execute a stored procedure on the DPS database. You can execute custom SQLs against the DPS database without having to write code to deploy via the Invoke Custom Method. You can create these actions for user initiated workflows or scheduled workflows.

This action requires that users know SQL and know how to write stored procedures.

To create a stored procedure action:

1. In the Navigation pane, select Settings > Workflow, and then select either User Initiated Workflows or Scheduled Workflows.
2. On the User Initiated Workflows form or Scheduled Workflows form, use the drop-down list in the header field to select the hub or other area, such as employees or billing terms.
3. In the Workflows grid (or Scheduled Workflows grid), select the workflow row (event) to which you want to add the action.
4. In the Actions grid, click Add Action > Stored Procedure.
5. In the Stored Procedure field on the Stored Procedure Configuration dialog box, enter a descriptive name for the procedure.
6. Under Arguments, set name-value pairs for each argument in the stored procedure.
7. If the stored procedure will alter the record that the user is currently working on, select the Reload Info Center Record option to have that record redisplay when the procedure completes.
8. If the stored procedure should be called only after all the user's changes are saved, select the Invoke after all changes are saved option. If you do not select this option, the action runs after the main workflow table has been saved, but before any of the grid tables have been processed.
9. Click Save. The action that you created is now listed in the Actions grid of the User Initiated Workflows form or Scheduled Workflows form.