Page 1 of 1

Query Jobs on Server

Posted: Mon Jun 19, 2017 7:30 pm
by hneff1
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.

Re: Query Jobs on Server

Posted: Tue Jun 20, 2017 8:08 am
by bartonv
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”.