Hi,
Generating statistics for multiple views from Scheduler is pretty simple.
To do that please, follow the steps described below:
1. Create a new VDP Scheduler job.
2. After naming the job, go to Extraction Section and select the desired VDP data source.
3. The Parameterized query should look like : CALL GENERATE_STATS('@viewname').
4. @viewname is a variable, that needs to be configured using the new panel that appears underneath the Parameterized query panel.
5. In the Non Parameterized Query panel you can choose the data source to set values to the @viewname variable.
You can choose a list, where you can specify all your views separated by commas.
You can choose to get the view names from VDP if you have a view in VDP the the names of the views.
You can use the stored procedure CATALOG_VIEWS() as follows:
select resultname as viewname from CATALOG_VIEWS()
6. In the mapping section, select the query parameter viewname and the source parameter from the Non Parameterized Query panel.
With this job configuration, Scheduler will execute the statistics for all your views.
Hope this helps!