Re: dbms_job failed to execute

Hi Magnus,

You can ignore the comments about going to a beginners list.

Some feel it is a somehow a waste of their time to see an easy question in this list, and then be forced to either skip it or delete it.

To deal with jobs that don't run, apply some basic troubleshooting techniques.

First read the docs about dbms_job. There you will find there is a DBMS_JOB.RUN procedure.

Simply login as the account that owns the job and run it: eg. exec dbms_job.run(15,true)

If there is a problem running the job from the scheduler, this method will usually fail as well, with the difference that you can see what the errors are.

If the job runs, but still fails from the scheduler, a next step might be to trace the job. This could cause a rather large tracefile - that depends on how long the job runs before failing. (google for 10046 traces. This can be enabled by modifying the job, logon trigger, etc.)

HTH,

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 10/27/05, Magnus Andersen <mag.andersen_at_gmail.com> wrote:


>

> I do frequently look at asktom. I've signed up for the new beginners list.

> Don't really know about other beginners lists. Also I was recommended this

> list from a Pro who stated that it had a lot of Oracle pros who didn't mind

> to help. Maybe he was wrong???

>

> One thing to keep in mind when targeting "beginners" is that I've seen

> several posts on here and even helped out an a few when it comes to shell

> scripting that I would most definitely consider beginner questions...

>

> Have to be careful when dealing with elitism.....

>

> Sincerely,

>

> Magnus

>

> On 10/27/05, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:

> >

> >  Have you ever considered a beginner list or asktom? .Maybe those forums

> > would be appropriate for you?

> >

> > I wouldn't object to you asking a question like this if it didn't end up

> > in my mailbox. I really think that

> >

> > this is not a forum for questions like yours.

> >

> >  --

> >

> > Mladen Gogala

> >

>

>

>

> --

> Magnus Andersen

> Systems Administrator / Oracle DBA

> Walker & Associates, Inc.

>


--
http://www.freelists.org/webpage/oracle-l