Re: dbms_job... Can i Stop it during a time interval ???

I don't think it is a good practise to kill the ora_snpX_SID process. Why don't you mark the job as broken for the time being?

Winnie Liu
DBA
Infonet Services Corporation
mailto:winnie_liu_at_infonet.com

Andy Hardy wrote in message <8vCHRBAeSH83Ewxu_at_ahardy.demon.co.uk>...
>In article <37EF93D2.99562C57_at_mediaplanning.com>, Eduardo Yanes
><eyanes_at_mediaplanning.com> writes
>>Hello.
>>
>>One of our application uses dbms_job to schedule tasks.
>>
>>The problem is ..... Some jobs are submitted at massive job intervals
>>using a bug in the "black box" application that uses this package (
>>dbms_job ).
>>
>>Should i stop the ora_snpX_SID process for a time interval ?
>>
>>Thanks.
>>
>>Eduardo Yanes.
>>
>>PD: Now we export the dbms_job table, kill the ora_snmpX_SId
>>processes... delete it... and at 21:00 import the table....
>You have a third-party application that is creating 'bad' intervals when
>submitting jobs?
>
>Have you tried using the dbms_job.interval and dbms_job.next_date, etc.
>procedures to correct the submitted jobs?
>
>Andy
>--
>Andy Hardy. PGP key available on request
>===============================================================
>
Received on Wed Sep 29 1999 - 00:24:03 CDT