Re: DBMS_SCHEDULER JOB CLASS

On Apr 8, 11:20 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> On Apr 7, 3:58 pm, PKNa..._at_gmail.com wrote:
>
> > I created a job class specifying a service. I find that the jobs do
> > not run when I use that job class. When I go back to the
> > DEFAULT_JOB_CLASS, they start to run again. I don't see any errors in
> > the alert log and since it doesn't look like it is being kicked off at
> > all, nothing in the *_SCHEDULER_JOB_LOG or
> > *_SCHEDULER_JOB_RUN_DETAILS. What am I doing wrong? Any ideas?
>
> Posting the same question more than once is one thing you're doing
> wrong. Such behaviour won't get you any faster response.
>
> How, exactly, did you create this job class? Did you grant EXECUTE on
> this new job class to the users creating jobs using it? Much more
> detail is necessary before anyone can truly tell you what may be
> wrong.
>
> David Fitzjarrell

I don't know how the message got posted twice. I don't recall submitting it twice, unless I hit the back button and it did the post again.

I followed the steps in the manual. I created the class using dbms_scheduler.create_job_class as sys. Granted execute to the user running the job and changed the attribute of the job to use this new job class. Received on Tue Apr 08 2008 - 19:44:22 CDT