Scheduling STARETL Process Runs
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.
Related Topics
Using Primavera Analytics Web Administration Application
Reviewing the Global Status of STARETL Runs
Reviewing the Status of Publication Service Runs
Starting and Restarting ODI Load Plans
Accessing Primavera Data Warehouse Log Files
Accessing Recent STARETL and Load Plan Logs
Last Published Friday, December 16, 2022