Re: DBMS_JOB question
From: Mattias Larsson <mattias.larsson_at_lule.frontec.se>
Date: 1996/04/24
Message-ID: <317E1F3C.4CE7_at_lule.frontec.se>#1/1
Date: 1996/04/24
Message-ID: <317E1F3C.4CE7_at_lule.frontec.se>#1/1
Dave Berry wrote:
>
> I want to schedule a one-time job to be run asynchronously and not be
> rescheduled for some future date. Can DBMS_JOB do this? If so, any
> examples would be much appreciated!
>
> Thanks.
>
> Dave Berry
> dberry_at_woodwind.com
> CMP Interactive
When the job is finished set the broken flag (DBMS_JOB.BROKEN) as the last line in your stored procedure. Broken jobs are never run.
You can always run the job again with DBMS_JOB.RUN
Hope I'm right.
Regards,
Mattias Larsson
Mattias Larsson Arctic Software AB Phone +46 920 751 81 Aurorum 1 Fax +46 920 752 99 S-977 75 LULEĆ… Cellular +46 70 51 751 81SWEDEN Received on Wed Apr 24 1996 - 00:00:00 CEST