Chapter 4, “Advanced Concepts and Tools”

The following information is not documented in “Managing jobs and scheduled tasks” in Chapter 4, “Advanced Concepts and Tools.”


Last result column of the Runtime Manager

[CR #584973] The Last Result column in the Runtime Manager displays a value of either Failed or Succeeded for any scheduled task that has already run. The same information appears in the Execution Result column of the Schedule Task List when viewed in the Web Monitor.

NoteSybase recommends that you do not use the Windows Task Manager or operating system command line to terminate scheduled tasks.


Configuring .odbc.ini file

[CR #589842] If you are using ETL Scheduler to set up a repeated task using a server that is running on UNIX, you must configure the .odbc.ini file on the UNIX machine to include a pointer to the repository data server.

StepsConfiguring .odbc.ini file

  1. Use a text editor to open the etc/.odbc.ini file.

  2. Add an entry similar to:

    [repository_data_server]
    uid=dba
    pwd=sql
    EngineName=demo
    CommLinks=tcpip(host=<hostname>;port=<portnumber>)
    AutoStop=no
    DatabaseName=demo 
    

    where repository_data_server is the name of the SQL Anywhere data server.

    NoteMake sure that the entry does not include the “AutoPreCommit” connection parameter.

  3. Save the file.

  4. In the ETL Scheduler, set up the repeated task, then run the job.