Connecting to Remote Databases with JDBC
RunMyJobs lets you use the JDBC standard to connect to third-party databases. You can query tables, execute stored procedures, and execute database-specific code. The process for using the JDBC Connector is as follows:
- Make the JDBC driver JAR file available to RunMyJobs.
- Create a JDBC Credential.
- Create a JDBC Database connection.
- Create a Job Server for JDBC.
- Create JDBC Job Definitions.
Note: For on-premises installations, JDBC connectivity requires the ProcessServerService.JDBC.limit
license key.