Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB Fail to run
THank For your advice , beside do you know how to create the job scripts ?
"Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon_at_ge.com> wrote:Well I think there are guys more qualified than me to answer this, but in my opinion dont trust on exp-imp for your jobs, the best approach is create the job scripts manually from your source db, and run it as the user you want to be the owner of the job on your target db, so you can be sure who owns every job.
Regarding your question on jobs not running, there's a lot of situations that may be happening, since you dont provide more info I only can give you some advice, pls issue a write to alert or user dump on your job, so this way you will be able to see if the job starts, if it does, then you need to verify if what you are calling from your job is running or not.
Hope this helps.
regards,
GAP
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kean Jacinta
Sent: Jueves, 04 de Agosto de 2005 09:46 a.m.
To: oracle-l_at_freelists.org
Subject: DBMS_JOB Fail to run
Hi ,
I come across some problem here, where by i exp a dmp file from another database that contains DBMS_JOB. I know that there are 16 job. But once i imp the dmp file into another server only 6 job gets created.
Is that possible to manually imp the job only ? Or any workaround ?
Another problem i encounter, the some of the dbms job is not running as expected. Infact when i check on the job...status is actually normal ? What are the problem that coz it ?
I am on Oracle 8i
Hope u understand.
Thank in Advanced
JK
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 04 2005 - 11:20:02 CDT
![]() |
![]() |