| Dbms jobs on a second instance [message #10534] |
Wed, 28 January 2004 21:50  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
We are using oracle 8.1.7. On this server we have multiple databases in two instances. We have a scheduled job on 2 databases in the first instance and that jobs works as it should.
On the second database the job just won't start. I had this problem before on a nother server but we god e new server and in the new instance it did work on that database. I think that it is because if you have a server with multiple instances you have to turn something on to make sure the dbms jobs will run.
variable jobno number;
begin
dbms_job.submit (:jobno, 'nawserver.timer;', trunc(sysdate + 1) + 1/24,
'trunc(sysdate + 1) + 1/24');
commit;
end;
This works ok except on the one database that is in a second instance. Do you have to turn something on in an instance so jobs like this will start?
I really hope someone can answer me this.
Patrick
Netherlands
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
