Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Content grammar corrected

...

Use JOE to create a PL/SQL job.

...

:

  • Open JOE's Job Wizard
  • Select JobSchedulerPLSQLJob in the list of available jobs and enter a job name
  • goto Goto "next" to set some parameters for the database connection etc.
  • follow above link See the reference documentation for the PL/SQLJob job to get more information about the parameter etc..after job parameters
  • After you have finished the wizard then you can insert the PL/SQL script in the script tab of the job.
  • alternatively Alternatively you can put the PL/SQL script in an external file and enter this filename in the parameter "command".

...