The SQLRunner plugin is a node step plugin included Rundeck Enterprise that executes a .sql script against a JDBC URL.

Usage

Add “SQLRunner Plugin” as a step in a workflow.

Provider name: org.rundeck.sqlrunner.SQLRunnerNodeStepPlugin

Configuration

  • SQL script path: Path to the sql script
  • JDBC Driver class name: e.g. com.mysql.jdbc.Driver
  • JDBC url: full JDBC url to use for connections
  • Database username connection username
  • Database password connection password
  • Auto commit flag: if true, a Connection::commit() will be called after the script.

Example Job XML