dbms_job failed to execute 2005-10-28 - By Jared Still
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@(protected)> 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@(protected)> 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.
>
Hi Magnus,<br>
<br>
You can ignore the comments about going to a beginners list.<br>
<br>
Some feel it is a somehow a waste of their time to see an easy<br>
question in this list, and then be forced to either skip it or delete it.<br>
<br>
To deal with jobs that don't run, apply some basic troubleshooting techniques.
<br>
<br>
First read the docs about dbms_job. There you will find there is a <br>
DBMS_JOB.RUN procedure.<br>
<br>
Simply login as the account that owns the job and run it:<br>
eg. exec dbms_job.run(15,true)<br>
<br>
If there is a problem running the job from the scheduler, this method will<br>
usually fail as well, with the difference that you can see what the errors are.
<br>
<br>
If the job runs, but still fails from the scheduler, a next step might be to<br>
trace the job. This could cause a rather large tracefile - that depends
on<br>
how long the job runs before failing. (google for 10046 traces. This can be<br>
enabled by modifying the job, logon trigger, etc.)<br>
<br>
HTH,<br>
<br>
-- <br>
Jared Still<br>
Certifiable Oracle DBA and Part Time Perl Evangelist<br><br><div><span class=
"gmail_quote">On 10/27/05, <b class="gmail_sendername">Magnus Andersen</b> <
<a href="mailto:mag.andersen@(protected)">mag.andersen@(protected)</a>
> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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???<br>
<br>
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...<br>
<br>
Have to be careful when dealing with elitism.....<br>
<br>
Sincerely,<br><span class="sg">
<br>
Magnus</span><div><span class="e" id="q_10732b90ae6b624e_2"><br><br><div><span
class="gmail_quote">On 10/27/05, <b class="gmail_sendername">Gogala, Mladen</b>
<<a href="mailto:MGogala@(protected)" target="_blank" onclick=
"return top.js.OpenExtLink(window,event,this)">
MGogala@(protected)</a>> wrote:</span><blockquote class="gmail
_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0
.8ex; padding-left: 1ex;">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">Have you ever considered a beginner list
or asktom? .Maybe those forums would be appropriate for you? </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">I wouldn't object to you
asking a question like this if it didn't end up in my mailbox. I
really think that</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">this is not a forum for questions like
yours. </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;"> </span></font></p>
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">--</span></font><font color="navy"><span style=
"color: navy;"></span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">Mladen Gogala</span></font><font color="navy">
<span style="color: navy;"></span></font></p></div></div></blockquote>
</div><br><br clear="all"><br></span></div><div><span class="e" id="q
_10732b90ae6b624e_3">-- <br>Magnus Andersen<br>Systems Administrator / Oracle
DBA<br>Walker & Associates, Inc.
</span></div></blockquote></div><br><br>
|
|
