Documentation client

For the scheduler a free full client Graphical User Interface (GUI) is available. The GUI contains all the scheduler functionality in an easy accessible way.

Everything that can be done with the full client can also be done with PL/SQL or SQL*Plus. The only difference is that the full client takes notice of the scheduler privileges a scheduler user has been assigned.
Functionality not available is greyed out (but still visible) and not accessible. If a scheduler user tries to use functionality not available in SQL*Plus or PL/SQL a scheduler error is generated.
Check the PL/SQL documentation for more details.

Back to top 

Installation

The GUI is written in Java so before the program can be used a Java Runtime Environment (JRE) needs to be installed. The minimal Java release must be 1.5.0.

The GUI also needs the jar file classes12.jar. This jar file is needed for setting up the connection with the Oracle Database.

Download the GUI, unzip the file Scheduler.jar and place it together with the classes12.jar file in the same directory.

Back to top 

Start

Go to the directory where the Scheduler.jar and classes12.jar are located and enter the following command to start the program:

java -classpath classes12.jar:Scheduler.jar scheduler.Scheduler
When starting the program on windows replace the : between the two jar files with a ;.

When everything works well the login plsql scheduler window should appear.

Screenshot PL/SQL scheduler window W00 Login Plsql Scheduler

Try to login and if this succeeds the installation is finished!

The name of the database, user and password are not case sensitive.
The directory where the Scheduler.jar file is located also has to be the working directory. Otherwise the icon's located in the jar file won't be loaded (all the functionality will still work).

If the icon's can't be loaded the following error will appear:

java.util.zip.ZipException: No such file or directory
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.(ZipFile.java:203)
        at java.util.zip.ZipFile.(ZipFile.java:84)
        at scheduler.JarResources.(JarResources.java:53)
        at scheduler.Scheduler.main(Scheduler.java:18)
  
Back to top 

Parameters

The client program can be started with up to four parameters.
The value of the parameters are pre-filled in on the login plsql scheduler window but can still be changed.

  1. Host.
    The hostname or the ip-address of the host where the Oracle Database is located.
  2. Port.
    The port number where the Oracle Database listener is listening on for new database connections.
  3. Database.
    The name of the Oracle Database.
  4. User.
    The name of the scheduler user.

In the next example the name of the host, port number, database and the scheduler user are passed as extra parameter values.

java -classpath classes12.jar:Scheduler.jar scheduler.Scheduler localhost 1521 XE plsqlsch

The login plsql scheduler window now should look like:

Screenshot PL/SQL scheduler window W00 Login Plsql Scheduler Back to top