Query Jobs on Server

Support questions related to CloverDXServer

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.

Posts: 147
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

Visit us online at http://www.cloverdx.com