Hi,
A quick way to query all of the views in a database is to use the [GET_VIEWS()](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) and [GENERATE_STATS()](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/generate_stats) functions included in the Denodo Virtual DataPort server.
Instead of using a list source in the Scheduler, create a data source connection to the desired Virtual DataPort database. You can run a query on the GET_VIEWS() function to return information about the views in the database. For example:
“SELECT name FROM GET_VIEWS() WHERE database_name = ‘<database_name>’”
would return all the names of views in the database "<database_name>". Keep in mind that this will update statistics for all views in the database. Make sure to add filters if you want to reduce the number of views this is applied to.
After adding a mapping from “name” to your parameterized query variable, the name of each view can be put into the “GENERATE_STATS(‘@<query_variable>’)” parameterized query and the Scheduler will automatically generate statistics for each view in your database.
Hope this helps!