Creating a JDBC Job Server

To create a JDBC Job Server:

  1. Navigate to Configure > Control > Job Servers\.
  2. Click New.
  3. Enter a name in the Name field.
  4. On the Services tab, click and select JDBCService.
  5. On the Definition Types tab, add JDBC.
  6. On the Parameters tab, add any Parameters you want to use (see below).
  7. Click Save & Close.

Parameters

The following JDBC-specific Job Server Parameters are available.

  • JDBCOracleDBMSOutput: Use Oracle DBMS Output?.
    • JDBCOracleDBMSOutputDestination: Either stderr.log or stdout.log. Defaults to stderr.log for CSV, and stdout.log for all others.
    • JDBCOracleDBMSOutputHeader: Header to print at beginning of DBMS output. Defaults to <h3>Output</h3><hr><pre> for HTML, <output> for XML, and nothing for all others.
    • JDBCOracleDBMSOutputFooter: Footer to print at end of DBMS output. Defaults to </pre></hr> for HTML, </output> for XML, and nothing for all others.
  • JDBCServer: An alternative Job Server to enable Queue jumping.
  • JDBCStatementFeedbackFormat Format of the SQL statement feedback in JDBC jobs. Options are Simple, Normal, and Extended.
  • JDBCStatementTimingFormat Should the duration of SQL statements in JDBC jobs be printed, and if so, in what format? Options are None, MilliSeconds, and Pretty.
  • DefaultRunAsUser: Though not specifically JDBC-related, this Job Server Parameter lets you specify the default Run As User for all Job Definitions running on the Job Server.
  • v7PLSQLApiAvailable: This Job Server Parameter is automatically set by the Job Server if the version 7 PL/SQL API is detected.

Adding an Object Reference to a JDBC Job Server

JDBC Job Servers need an Object reference named Jdbc_ProcessServer_Database_Ref pointing at the database containing the database connection settings. To add such an Object reference, issue the following code in the RunMyJobs Shell (Configure > Automate > Scripting tools > Shell):

Copy 
{
  Partition p = jcsSession.getPartitionByName(<partition>);
  Database db = jcsSession.getDatabaseByName(p, <database_object_name>);
  ProcessServer ps = jcsSession.getProcessServerByName(p, <process_server_name>);
  ObjectReference objRef = ps.createObjectReference(db);
  objRef.setName("Jdbc_ProcessServer_Database_Ref");
  jcsSession.persist();
}