You can run a workflow from the Orchestrator client to test the dropping of 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 drop table example workflow. |
3 | Right-click the JDBC drop table example workflow and select Start workflow. |
4 | Provide the required information, and click Next.
a |
Type a password to access the database.
|
b | Type a database connection URL. |
c |
Type a user name to access the database.
|
|
5 | Type an SQL drop statement.
An example syntax is:
DROP TABLE "table_name"
|
6 | Click Submit to run the workflow. |