Query Jobs on Server

hneff1

• June 19, 2017 00:00

• Answered

Follow

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.

• 

  Vladimir Barton

  • June 20, 2017 07:08

  0

  Comment actions Permalink

  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:
  
  

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

Please sign in to leave a comment.