Query Jobs on Server

Support questions related to CloverETL Server

hneff1
Posts: 16
Joined: Fri May 22, 2015 7:53 pm

Query Jobs on Server

Postby hneff1 » Mon Jun 19, 2017 7:30 pm

Is there an easy way to get a list of jobs you have scheduled on Clover Server; ie show me the list of all enabled scheduled jobs on the clover prod server. I know there is an underlying database that stores the data. Just not sure if you have some documentation on accessing it. Thanks.

bartonv
Posts: 32
Joined: Wed May 03, 2017 12:10 pm

Re: Query Jobs on Server

Postby bartonv » Tue Jun 20, 2017 8:08 am

Hello hneff1,
querying the CloverETL Server database for a list of all enabled scheduled jobs heavily depends on the type of the database you are taking advantage of (Microsoft SQL Server, MySQL, Derby etc.) Nevertheless, the database structure for storing this information, such as server scheduled jobs, is generic within Clover so you can use this simple SQL query to do the trick:

Code: Select all

SELECT * FROM `dbName`.`schedule`
WHERE `enabled_switch` = 1

Note: replace the “dbName” with the actual name of your database. The scheduled jobs are stored in the “schedule” table and the field that drives the enabled/disabled logic is “enabled_switch”.
---
Vladimir Barton
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support