Procedure for scheduling ETL with UNIX Cron
Specify man crontab in the command prompt window to start Cron help.
-
To edit Crontab in VI, specify:
Crontab -e
.This enables to set up scheduled events. View a list of events with the scheduled execution time in this sequence:- Minutes
- Hours (24 hour time format)
- Day of the month
- Month
- Day of the week
- Path to the batch file (for example, etl.sh)
-
Edit the
etl.sh at
ETL_Tool/bin and set the absolute paths of
JAVA_HOME and
ETL_HOME variables. For example,
JAVA_HOME=/reports/JVM/Unix ETL_HOME=/reports/ETL_Tool
-
Specify this information to add the ETL job to the scheduler
* * * * * /reports/ETL_Tool/bin/etl.sh -conf_dir "/reports/ETL_Tool/conf"
Each asterisk (separated by spaces or tabs) represents a time field in this order, from left to right: Min, hour, day of month, month, and day of week.
These are the valid values for each of the time units:
- minute (0-59),
- hour (0-23),
- day of the month (1-31),
- month of the year (1-12),
- day of the week (0-6 with 0=Sunday).