Collect
Schedule Updates to Tables
The Schedule Updates functionality clears or updates all manually set source and table schedules to provide mass updates to schedules for targets and sources.
This feature covers the following topics:
Clear All Schedules
If the target does not need to be refreshed anymore, clear all schedules.
To clear all schedules for targets and sources:
- Select Tools > Bulk Table Schedule Update in Navigation pane.
-
Click Edit.
View the field descriptions for the Bulk Table Schedule Update page.
- Select a target database from Schedule Target list box.
-
Select a source database from Schedule Source list box. This field maybe left blank for a Clear Schedule process, but must be populated for an Update Schedule process
OR
Leave Schedule Sources blank to update all sources.
- Click Save.
- Click Clear Schedule; a confirmation message displays. If Schedule Source is blank, all sources for the selected target are cleared.
- Click Ok.
Update All Schedules
If all targets need to be refreshed at a time other than on the schedule defined for the targets, use this feature to update all the schedules at once.
To update all schedules for a target and a source:
- Select Tools > Bulk Table Schedule Update in Navigation pane.
-
Click Edit.
View the field descriptions for the Bulk Table Schedule Update page.
- Select a target database from Schedule Target list box.
-
Select a source database from Schedule Source list box.
OR
Leave Schedule Sources blank to update NULL or empty sources.
- Select a schedule to Schedule To list box.
- Click Save.
- Click Update Schedule; a confirmation message displays.
- Click Ok.