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”.