You can translate the question and the replies:

Parameterizing GET_STATS_FOR_FIELDS Scheduler job to automatically refresh the stats for all enabled views.

Hey, we are trying to use GETSTATSFORFIELDS in a Scheduler job to automatically refresh the stats for all views with statistics enabled. With LIST VIEWSTATSUMMARIES on myVdb I can get a list of all the views in the VDB, that have statistics enabled. Now I would like to use a scheduler job to update the statistics for all these views. I used call GET_STATS_FOR_FIELDS ( 'ATSOURCE_THROUGH_VDP_ONLY' , '_common' , '@view' , null, true, false, false, true) defining view = LIST VIEWSTATSUMMARIES on myVdb Is there a way to make this work? For now, I manually create a comma separated list of the respective views, but this is not very dynamic. Best regards, David
Denodo Scheduler 8.0 Gather Statistics
user
24-05-2022 11:34:03 -0400
code

2 Answers

Hi, If I would face such a scenario, I would refer to the similar **[Q&A]( https://community.denodo.com/answers/question/details?questionId=9064u000000wkH4AAI&title=Result+of+LIST+VIEWSTATSUMMARIES+in+GET_STATS_FOR_FIELD )** and follow the steps to create my VDP scheduler job that calls the GET_STATS_FOR_FIELD stored procedure with respect to dynamic view names. Furthermore, if you still face the issue and you are a valid support user, you could create a support ticket in the **[Denodo Support Site](https://support.denodo.com )** so that the Support Team would help you. Hope this helps!
Denodo Team
25-05-2022 09:30:57 -0400
code
Hello, yes, that solved our Problem. Best regards
user
03-06-2022 05:25:18 -0400
You must sign in to add an answer. If you do not have an account, you can register here