You can translate the question and the replies:

identify views in scheduler jobs

Hi Team, If we have multiple jobs in denodo scheduler, than how to find which view can be in which job ? Thanks.
user
15-02-2022 00:57:04 -0500
code

1 Answer

Hi, I understand that you have to find the views used in the Scheduler Jobs. I would suggest you use [**Scheduler API**](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/developer_api/developer_api). The API of Denodo Scheduler allows you to interact with Scheduler programmatically and develop extensions for it. You could also develop a tool to retrieve all the jobs and examine their configuration in order to determine which of them use a view (using the VDP data source, the database name, and the view name values). In the case of jobs of type VDP, you could check if the view name is contained in the query stored in its configuration. In the case of jobs of type VDPCache/VDPIndexer, the view name together with the database name is stored in a field of its configuration. Hope this helps!
Denodo Team
15-02-2022 07:32:59 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here