Work with Dataset Reload Schedules

This topic describes what you need to know to create, modify, and manage dataset reload schedules.

Topics:

• Schedule a Dataset Reload

• View a Dataset Reload Schedule's Details

• Modify a Dataset Reload Schedule

• Delete a Dataset Reload Schedule

Schedule a Dataset Reload

You can create a one-time or repeating schedule to reload a dataset's data into cache.

Schedule a dataset reload when you want to make sure that you dataset is automatically reloaded regularly and you don't want to have to remember to run it manually. Also, you can schedule a dataset reload for a day and time that is convenient for and doesn't interrupt or confuse workbook authors or consumers.

You can't schedule a reload (that is, the New Schedule option doesn't display in the Actions menu) if:

• A dataset contains only tables that are set to Live.
• A dataset uses only files.
• A dataset uses an Oracle EPM Cloud or Oracle Essbase connection.

Dataset tables with the Data Access field set to Live aren't included in the reload. See Specify Whether a Dataset Table Is Cached or Live.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Hover over the dataset that you want to reload, click Actions (), and then click New Schedule.
   
   
   Description of the illustration data_set_schedule_new.png
   
   
4. Specify when and how often you want the dataset reload to run.
5. Click OK.

View a Dataset Reload Schedule's Details

You can view information about a dataset reload's schedule to find out when it last ran and when it will next run. You can also view historical information about the completed reload jobs run by the schedule.

You can access details about the dataset reload schedules that you create. You can't access dataset reload schedules that other users create. Administrators with the BI Service Administrator role and users who've been given Read-Write or Full Control permissions to the dataset can access its schedules.

For complete historical information about the tables that the scheduled job reloaded, see View a Dataset's Reload History and View or Download a Reload Job's Log Files.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Locate the dataset that you want schedule information for, click Inspect, and then click Schedules.
4. Click the name of a schedule, and in the Schedule dialog click the General and Schedule tabs to view information about the schedule.
5. Optional: Click the History tab to view a list of the schedule's completed jobs. Click a job to drill down for more information about it, such as its start time and completion status.
6. Click OK.

Modify a Dataset Reload Schedule

You can change the details of a dataset reload schedule. For example, when and how often you want the dataset reload to run.

You can modify the dataset reload schedules that you create. You can't access and modify dataset reload schedules that other users create. Administrators with the BI Service Administrator role and users who've been given Read-Write or Full Control permissions to the dataset can modify its schedules.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Locate the dataset that you want to modify schedule information for, click Inspect, and then click Schedules.
4. Click the name of a schedule, and in the Schedule dialog click the Schedule tab.
   
   
   Description of the illustration data_set_reload_schedule_detail.png
   
   
5. Update the schedule details.
6. Click Save.

Delete a Dataset Reload Schedule

You can delete a dataset's reload schedule when you no longer need it.

You can delete the dataset reload schedules that you create. You can't access and delete dataset reload schedules that other users create. Administrators with the BI Service Administrator role and users who've been given Read-Write or Full Control permissions to the dataset can delete its schedules.

After you delete a schedule, you can still view the historical information about the reloads it ran and completed. See View a Dataset's Reload History.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Locate the dataset that you want to delete a schedule for, click Inspect, and then click Schedules.
4. Hover over the name of a schedule and click Delete.
5. Click Close.