The remote table can be refreshed from the Scheduler Administration Tool by following the steps below:
Login in to the Scheduler Administration tool and create a new job
* Click on Jobs>Add Job>VDP
Then under the Extraction Section
* Data Source, select VDP from drop down
In the Parameterized Query box, use the [REFRESH](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/refresh_views/refresh_views#refresh-statement) command as follows -
* `REFRESH <RemoteTableViewName>`
Save the job and execute.
You should now be able to refresh the remote table using this scheduler job. This will truncate and update the remote table in the data source, execute the load query in the Virtual DataPort server
Optional: To run this refresh job periodically, the [Trigger](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/time-based_job_scheduling_section) Section can be configured.
To create a remote table using the scheduler, create a scheduler VDP job as mentioned above and in the extraction section CALL the [CREATE REMOTE TABLE](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/create_remote_table#create-remote-table) stored procedure under the “Parameterized query” option such as this [example](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/refresh_views/refresh_views#refresh-statement:~:text=data%20load%20query.-,Example%3A,-The%20following%20example).
Hope this helps!