Procedure for scheduling ETL with UNIX Cron

Specify man crontab in the command prompt window to start Cron help.

  1. 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)
  2. 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
    
  3. 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).