To schedule a STARETL process run for a data source:
- Sign in to the Primavera Analytics Web Administration Application.
http://<host>:<port>/p6rdb
- In the sidebar, select Status.
- From the Home menu, select a staretl<id> or a <Custom Name for DataSource>.
Note: <id> is the identifier of the data source.
- From the Actions menu, select Schedule Etl.
- In the Schedule Frequency field, select the frequency for the STARETL process run.
- If you select None, no STARETL runs will be scheduled for a data source.
- If you select Daily:
- In the Run ETL at field, enter the time for the daily process run.
- Select Save.
- To set up multiple ETL schedules daily, select Add and enter date and time for the ETL run.
Note: Schedule multiple ETLs daily at least 2 hours apart.
- If you select Weekly:
- In the Run ETL at field, enter the time for the process run.
- Select the days for the STARETL process run.
- Select Save.
- (For non-ODI on-premises installations only) In the Log Level field, select the level of detail to be included in the ETL log of the scheduled STARETL process run:
- Extra Debug Information: For more fine grained information on each step and script that is run. It also includes general information, errors, and warnings.
- Debug and Trace Information: For detailed output of each script, query, and connection. It also includes general information, errors, and warnings.
- General Information (default): For errors, warnings, and informational messages on the progress of each step.
- Errors and Warnings: For errors and warnings only.
- Errors Only: For errors only.
- Select Save.
Note: You can also use Task Scheduler (with Windows) or a cron job (with UNIX or Linux) to schedule STARETL process runs. See the Primavera Analytics On-Premises Administration Guide for details.