None of the job's targets, parameters etc have been changed.
No errors are reported in the Show Output from the OEM as shown below:
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 30 17:22:04 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name...
Via the Oracle Manager Server.
These jobs have been working file upto the middle of last week when we noticed that the new jobs or the modified jobs were not working.
The jobs do commit,
The test procedure I am using is as basic as you can get and is shown below:
as
begin
delete from ae;
insert into ae (debug_col) values ('Table Updated');
commit;
end;
Where debug_col is a varchar2(100).
We have two Oracle 9.2 Servers and when we publish jobs to both servers they both report that the jobs have completed with no errors, but when we examine the tables it is obvious that the jobs are not being executed.
Does anyone have any idea what is going on here?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.