| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB Fail to run
Beside how to determine my dbms_job really run?
Check on dba_jobs_running ... show nothing Check on dba_jobs .... did show job alrdy run.
> 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
>
<http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif>
> ,
>
> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 04 2005 - 19:47:30 CDT
 |
 |
