Re: submit jobs

From: Ivan <ivan_at_protek.ru>
Date: Thu, 18 Nov 1999 19:56:07 +0300
Message-ID: <38342FA7.85E05920@protek.ru>

Hi, All!

Andreas Schwaiger wrote:

> i want to run a procedure as a job in the background
>
> i tried this:
> DBMS_JOB.SUBMIT(jobno,proc_name,sysdate+1/(25*60));
> nothing happens
>

• in Sql*Plus You can set task:

var J number;

begin

  dbms_job.submit(:J,                  /* job */
         'ivan.fsnap_analyze_resurs;',       /* what */
         TRUNC(SYSDATE)+19/24,          /* next_date = in 19:00 today*/
         'SYSDATE+6/24',            /* interval every 6 hours */
         FALSE);          /* no_parse  IN  BOOLEAN DEFAULT FALSE */

end;
/
commit;
print J

• and can see sheduled tasks select job, rpad(LOG_USER || ' ' || PRIV_USER || ' ' || SCHEMA_USER,15) n, rpad(what,35) what, LAST_DATE, THIS_DATE, NEXT_DATE, rpad(INTERVAL, 25) INTERVAL, decode(BROKEN, 'N','not broken', 'broken') BROKEN, failures from all_jobs where /* job=:j */ what like '%ivan.%' ;
• and You can correct time

execute dbms_job.change(1222, null,TRUNC(SYSDATE)+19/24, null);

• J == 1222

>
> then I tried this:
> DBMS_JOB.SUBMIT(jobno,proc_name);
> DBMS_JOB.RUN(jobno,true);
>
> Now the procedure proc_name is running, but I have to wait until its
> finished.
> Who can help me?
>
> Andi Schwaiger
> Austria

Ivan Received on Thu Nov 18 1999 - 10:56:07 CST