RE: dbms_job failed to execute

Some people (I will not mention any names, of course) feel that asking questions without doing even

a minimal investigation is disrespectful to oracle professionals who did invest some work into becoming

oracle professionals. Some people will probably continue to discourage such lazy beginners by using

all means at their disposal. Some people are equally entitled to their opinion as you are to yours.

The first amendment of the email lists reads as follows:

Moderator shall make no rule respecting an establishment of religion, or prohibiting the free exercise thereof; or abridging the freedom of speech, or of the press; or the right of the people peaceably to assemble, and to petition the moderator for a redress of grievances.

--

Mladen Gogala

Ext. 121

From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Friday, October 28, 2005 12:33 PM
To: mag.andersen_at_gmail.com
Cc: Oracle-L Freelists
Subject: 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 <mailto: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 < <mailto:MGogala_at_allegientsystems.com> 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 Received on Fri Oct 28 2005 - 13:22:37 CDT