Agent Type 112 - Execute Stored Procedure
Use Agent Type 112 - Execute Stored Procedure to execute a stored procedure in WorkBook. This agent looks in the AgentSetupSP table in the WorkBook database and runs any stored procedure from this location.
What is a Stored Procedure?
A stored procedure is a string of SQL code that is saved in WorkBook so that it can be executed on demand.
Important: This agent can perform any function within an SQL query and is not limited to just running SELECT queries. It can execute any UPDATE / DELETE functions that are in the selected stored procedure.
CAUTION: Use caution when executing a stored procedure using this agent because it makes changes directly in the WorkBook database.
Parameters
| Field | Description |
|---|---|
| 494 - Stored Procedure Name | Select the stored procedure that you want to run.
Note: The stored procedure must be saved in the
AgentSetupSP table in the database. Otherwise, the procedure will not be displayed in this drop-down menu.
|
Recommended Schedule
The recommended schedule for this agent depends on the nature and size of the SQL query in the stored procedure, as well as the amount and nature of data that is affected/retrieved by this query. For example, there might be some stored procedures that need to be run just once, whereas others might need to be run more frequently.