Procedure for scheduling ETL with Windows AT

Before using AT, the Schedule service must be running on the target computer.

To display all the available commands for the AT tool, specify AT -help in the command prompt window.

To schedule ETL with Windows AT:

  1. Specify: NET START ¦ MORE and search for:
    Task Scheduler
    Start the scheduler if it is not there:
    NET START "Task Scheduler"
    (You can also use "Services" in the Control Panel to start the scheduler)
  2. Edit the etl.bat file in the ETL_Tool/bin and set the JAVA_HOME and ETL_HOME variables to their absolute paths. For example,
    • set JAVA_HOME=C:\Reports\JVM\Windows
    • set ETL_HOME=C:\Reports\ETL_Tool
  3. Specify this information to add an ETL job to the scheduler.

    AT 23:00 /Every:M,T,W,Th,F,S,Su CMD /C C:\dev\Reports\ETL_Tool\bin\etl.bat -conf_dir "C:\dev\Reports\ETL_Tool\conf"

    '23:00' specifies the time when the ETL process must run; the 'Every' parameter specifies the frequency of the ETL process runs (can be numeric 1, 2, 3, and so on); C:\dev\Reports\ETL_Tool\bin\ specifies where the etl.bat file is located, and "C:\dev\Reports\ETL_Tool\conf" specifies where the ETL configuration files (for example, ETL.xml) are located.

    There can be other specific requirements (for example, running ETL remotely and drive mappings, and so on) for some customer installation, but the above example explains a simple scheduling of ETL. For more information on the AT command, see Microsoft Windows Server Administrator's guide.

    The AT command runs as a background process, for which the output does not exist. To redirect the output from the command prompt to a file, use the redirection symbol (>). The redirection symbol must be preceded by the escape symbol (^). For example, specify this information to redirect output to the etl_scheduling.log file:

    AT 23:00 /Every:M,T,W,Th,F,S,Su CMD /C C:\dev\Reports\ETL_Tool\bin\etl.bat -conf_dir "C:\dev\Reports\ETL_Tool\conf" ^>c:\dev\ETL_Tool \Reports\logs\ etl_scheduling.log