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 17:45:28 -0700 (PDT)
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.
--- "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
>
<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
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
