Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

Programs Tab

(Only for Oracle 10g release or later)

A program defines what the Scheduler will execute. A program's attributes include its name, type (for example: a PL/SQL procedure or anonymous block), and the action it is expected to perform. A program can also accept zero to many arguments, which makes it a flexible building block for constructing schemes of tasks to be scheduled.

Button Description

New

Click to create a program

  1. Enter a Program Name.
  2. Select a Type, that is PL/SQL Block, Stored Procedure or Executable.
  3. If you do not want the program to be enabled by default, clear the Enabled check box.
  4. Define the Action the program is to perform.
  5. For PL/SQL Block or Executable, enter the relevant command string.
  6. For Stored Procedure, select one of the available stored procedures from the database.
  7. Enter any Comments if required
  8. Click Save.
Save Save changes to a selected program or a new program.
Advanced Edit available Attribute Values for the selected item.
Drop Remove the selected item from the database.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating