RE: DBMS_JOB Fail to run
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Aug 2005 09:17:59 -0700 (PDT)
THank For your advice , beside do you know how to create the job scripts ?
"Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Kean Jacinta
Sent: Jueves, 04 de Agosto de 2005 09:46 a.m.
To: oracle-l@xxxxxxxxxxxxx
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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
