| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_job question
John,
The reply is late coz I have not been checking the
mail... anyway you could have a procedure setup as a
job to monitor these jobs. Fire it before users start
using the db and reset the jobs next(using dbms_job)
if any job is scheduled to execute before the day end
when users leave.
I use this also to keep me posted(by sending email)
if any job has not executed.
Shailesh
--- John Dailey <John.Dailey_at_concept-solutions.com>
wrote:
> Hey List, I have a bit of a puzzler or I need a
> brain transplant, which I
> may need regardless =) :
>
> I have a couple of jobs that I have changed the
> interval of so they run at
> night. No problems there... however, they are
> currently scheduled to run in
> the middle of the day and they won't pick up the new
> interval time until
> they complete successfully. I can't let them
> complete because when they
> kick off everyone starts complaining.
>
> To avoid the use of earplugs to block the users'
> whining, does anyone know
> of an equivalent to dbms_job.next_date that will
> update the next_sec column
> (which controls the time) of the dba_jobs table?
>
> Thanks in Advance - Metalink wasn't much help on
> this one.
>
>
> John Dailey
> Consultant
> Concept Solutions, LLC
>
> Concept Solutions, LLC
> *Your Business Intelligence Partner*
> www.concept-solutions.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: John Dailey
> INET: John.Dailey_at_concept-solutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
 |
 |