Connect Jenkins and Oracle Database

Both apps 28Jenkins 16Oracle Database 12

• Trigger
  New build

  Triggers when a new build of the chosen Jenkins job starts.

• Trigger
  New Job

  Triggers when a new job is added to your Jenkins server.

• Trigger
  New Job Status Notification

  Triggers when a job starts a new build.

• Action
  Add job by copying

  Creates a new Jenkins job by copying the configuration of an existing job.

• Action
  Build Job

  Starts a new build of a job, optionally with build parameters. The build is queued and the queue item's location is returned.

• Action
  Delete Job

  Permanently deletes a job and its build history.

• Action
  Delete queue item

  Removes a waiting item from a pipeline's build queue so it never runs.

• Action
  Disable Job

  Disables a job so it no longer builds.

• Action
  Enable Job

  Enables a disabled job so it can be built again.

• Action
  Get Job

  Returns a job's details, including its builds, health and last build results.

• Action
  Get Last Build

  Returns the most recent build of a job, with its number, result, duration and whether it is still running.

• Action
  List builds

  Returns every build of a Jenkins job, newest first, with each build's number, result and timing.

• Action
  List Jobs

  Returns the jobs on your Jenkins server with each job's name, URL and status color.

• Action
  List Nodes

  Returns the build agents (nodes) on the Jenkins server with whether each is online and idle.

• Action
  List Queue Items

  Returns the builds waiting in the Jenkins build queue.

• Action
  Stop Last Build

  Aborts the most recent build of a job if it is still running.

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.