You can run a workflow from the vRealize Orchestrator Client to delete all entries from a JDBC table.

Prerequisites

Verify that the user account you are logged in with has the necessary permissions to run JDBC workflows.

Procedure

  1. Navigate to Library > Workflows and enter the jdbc_examples tag in the workflow search box.
  2. Locate the JDBC delete all from table example workflow and click Run.
  3. Provide the required information.
    1. Type a database connection URL.
    2. Type a user name to access the database.
    3. Type a password to access the database.
  4. Type an SQL delete statement similar to the following example syntax.
    DELETE FROM "table_name"
  5. Click Run.