| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't get Oracle job to start running.
On 20 Sep 97 02:20:03 GMT, tkupp_at_pacifier.com (RastM) wrote:
>SCO OpenServer 5.0.2
>Oracle Workgroup Server 7.3.2.2.0
>
>I cannot get a PL/SQL procedure to run as a job. It just sits there in
>USER_JOBS with a NEXT_DATE of the time it was supposed to have run, and no
>LAST_DATE but it will not start executing. I can force it to run with the
>DBMS_JOB.RUN procedure, but otherwise, it will not start up by itself.
>The job never shows up in DBA_JOBS and, of course, DBA_JOBS_RUNNING.
>
>I set the JOB* parameters in init.ora as
>
> job_queue_processes = 1
> job_queue_interval = 60
>
>The *SNP* process appears to be running.
>
>The procecure I am trying to call has been declared as
>
> CREATE OR REPLACE
> PROCEDURE sleeptwo AS
> start_date DATE;
> i NUMBER;
> BEGIN
> INSERT INTO timings_tmp VALUES ('sleeptwo START', sysdate);
>
> start_date := sysdate;
>
> WHILE sysdate - (30/86400) < start_date
> LOOP
> i := i + 1;
> END LOOP;
>
> INSERT INTO timings_tmp VALUES ('sleeptwo END', sysdate);
> END sleeptwo;
>
>This works just fine if executed with
>
> BEGIN sleeptwo; END;
>
>but if I try submitting it as a job with
>
> VARIABLE jobno number;
> begin
> DBMS_JOB.SUBMIT (:jobno, 'sleeptwo;', SYSDATE + (60/86400), NULL);
> end;
>
>it doesn't want to start up.
>
>Any suggestions?
Are you commiting at some point in time? if you run dbms_job (it is transactional) and don't commit, the job will be visible to you in your session but not to the SNP process that runs them.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |