How do I schedule a SQL script to run as a job in SQL Navigator. (4302879)

User has a script that needs to be ran on a certain day, certain time and would like to schedule it as a job.

How to Schedule a Job to Run in SQL Navigator

1. Go to Tools | Job Scheduler.


2. From the Job Scheduler pane, click on New.


3. From the New Job Wizard, you can either use the system proved job name (e.g. JOB$_43) or user your own. Select if you want to run your job as a PL/SQL block or if your job is a stored procedure.

If you select Stored Procedure, you can select any stored procedure in your database. If you select PL/SQL Block, you have to rewrite you SQL to embed it in a PL/SQL block. Consult your Oracle literature as to how this could be done.

For this solution, we will move forward with PL/SQL Block selection by clicking Next.


4. The SQL we want to run as an example is

SELECT first_name FROM employees
WHERE last_name = â??Kingâ??;

We have to convert that to an anonymous block. Again, consult your Oracle text as to how.


5. Let us assume we want to execute the example SQL hourly starting 1/9/08. Type in the start date, a start time, and check Hourly. Then click Next.


6. You can select repeat this job until you manually drop it or until a specify time. Click on Finish.


7. Click on Save to save this job.


8. The new job is now saved and ready for execution.


9. Use the Job Log tab to track your jobs.

If 'Job Scheduler' is missing from the Tools menu, then the user may not have the necessary privileges. Please review the Help contents for Job Scheduler which will detail the required privileges for scheduling jobs.