Use the Stored Procedure action to execute a stored procedure on the PM Compass database. You can execute custom SQLs against the PM Compass database without having to write code to deploy via the Invoke Custom Method option.
For more information, see Stored Procedure Overview.
To create a Stored Procedure action for a workflow, complete the following steps:
Display the Alerts form. How?
Select an Area type from the drop-down list. This field dictates the area of PM Compass to be used in the alert’s conditions and actions.
In the Alerts grid, select the workflow row (event) to which you want to add the action.
In the Actions grid, click Insert and select Stored Procedure.
Complete the fields on the Stored Procedure Configuration Dialog Box.
Complete the field in the Arguments grid.
Click Save.