Scheduled job running late.
Hi all,
** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community
members can add their perspective, experience or knowledge. This will further enhance all knowledge bases
including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling
richer solution searches.**
Database 10.2.0.4 on Linux x86-64
Problem :
Have job that needs to run every night at 3 am and it runs every day at 3 pm.
Below is the job script:
BEGIN
SYS.DBMS_JOB.REMOVE(68);
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'AUTOMATIONTOOLPROC;'
** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community
members can add their perspective, experience or knowledge. This will further enhance all knowledge bases
including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling
richer solution searches.**
Database 10.2.0.4 on Linux x86-64
Problem :
Have job that needs to run every night at 3 am and it runs every day at 3 pm.
Below is the job script:
BEGIN
SYS.DBMS_JOB.REMOVE(68);
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'AUTOMATIONTOOLPROC;'
0