You can run a workflow from the Orchestrator client to delete all entries from a JDBC table.
Prerequisites
Log in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 | Click the Workflows view in the Orchestrator client. |
2 | In the workflows hierarchical list, open to navigate to the JDBC delete all from table example workflow. |
3 | Right-click the JDBC delete all from table example workflow and select Start workflow. |
4 | Provide the required information, and click Next.
a | Type a database connection URL. |
b |
Type a user name to access the database.
|
c |
Type a password to access the database.
|
|
5 | Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name"
|
6 | Click Submit to run the workflow. |