Creating Job (or scheduling of SQL scripts)

Hey all,

I'm trying to schedule a SQL script to run at a regular interval (1/2 hour). I am using the OEM (Oracle 8.1.5, OEM version 2.04) to create a job to perform this task. I can create a job, but, no matter what I use for the SQL script, the job shows completed without errors, but, the script does not run. (I can type complete nonsense in for the script and still show job complete without errors) The documentation suggests adding a line such as "whenever sql error" (I don't have the exact syntax in front of me). I can add that line, but, to no avail. If I take a copy of the SQL script and run it under a SQL worksheet, it works.

Is there a problem with calling stored procedures from this job?

I have never tried to set up a job this way. Any suggestions about what I might be doing wrong? Another way of doing?

Thanks much,

Doug

dpeel_at_mindspring.com Received on Tue May 02 2000 - 00:00:00 CDT