1

Topic: dbms_scheduler job running twice

Kind time of days!
dbms_scheduler job fulfilled twice in what there can be a reason?
More low determination job'a and a screen of dens.

begin
sys.dbms_scheduler.create_job (job_name => ' my_job ';
job_type => ' PLSQL_BLOCK ';
job_action => ' my_procedure ';
start_date => to_date (' 10-03-2016 9:10:16 AM ', ' dd-mm-yyyy hh24:mi:ss');
repeat_interval => ' Freq=DAILY; ByHour=1 ';
end_date => to_date (null);
job_class => ' my_job_class';
enabled => true;
auto_drop => true);
end;
/

2

Re: dbms_scheduler job running twice

Though 08.08 and 09.08 fulfilled as it is necessary on time.

3

Re: dbms_scheduler job running twice

itzik;
SELECT * FROM dba_scheduler_job_log where job_name = ' my_job'

4

Re: dbms_scheduler job running twice

feagor wrote:

itzik;
SELECT * FROM dba_scheduler_job_log where job_name = ' my_job '

5

Re: dbms_scheduler job running twice

feagor,

6

Re: dbms_scheduler job running twice

itzik wrote:

auto_drop => true);

Surrenders to me, you not to us tell all.  are formed program?

7

Re: dbms_scheduler job running twice

And through what tool launched?
SESSION_ID (SID, SERIAL#) shows, what it is different connections (flows?) one session

8

Re: dbms_scheduler job running twice

dmdmdm;
Yes is not present, on idea all. Formed not by me and for a long time. Program they are not formed.

9

Re: dbms_scheduler job running twice

Vyacheslav Ljubomudrov;
On idea a patch put this , a script in sqlplus rolled also all.
Manually there is no possibility to launch.

10

Re: dbms_scheduler job running twice

Vyacheslav Ljubomudrov;
The only thing, recently it to job class' anchored and here after that received such result.