Re: Job Scheduler Forecast

Hi Donald,

There is a view called "DBA_SCHEDULER_JOBS" that will tell you who has a job to run in which window. DBA_SCHEDULER_WINDOWS gives you the details of the windows. If you want to schedule a maintenance, here is how to do it:

https://docs.oracle.com/database/121/ADMIN/tasks.htm#ADMIN12333

BEGIN
   dbms_scheduler.disable(
     name => 'SATURDAY_WINDOW');
   dbms_scheduler.set_attribute(

     name      => 'SATURDAY_WINDOW',
     attribute => 'DURATION',
     value     => numtodsinterval(4, 'hour'));
   dbms_scheduler.enable(
     name => 'SATURDAY_WINDOW');

If you need to just stop everything immediately, you can turn job_queue_processes to 0 and nothing will run.

Oracle cannot give you what you want. Users have their jobs and Oracle cannot know what is important from the business perspective and what is not. While I was a DBA, I used "wedding process": announce maintenance in two weeks and explain that the jobs will not run. If someone has to say anything against that, raise your objection now or remain forever silent. If nobody objected, the maintenance window was scheduled. Frequently, I asked users to disable their jobs themselves. However, the list of authorized people was rather short. Each business application had a project manager, who had a list of batch jobs and knew what each of them was doing.

Regards

On 08/26/2017 06:43 AM, Freeman, Donald G. CTR wrote:
> In the latest iteration of our suite of applications a lot of manual batch
> jobs running on the server were brought into the database and scheduled
> through the 12c Job scheduler. We have a few hundred jobs running under
> different service accounts. What I didn't get in this new version was a
> forecasting tool for maintenance which would allow give me an overview of
> the whole thing so I could plan maintenance. We normally do maintenance on
> Saturdays but it's a hit or miss thing trying to thread the needle, figure
> out what to allow to finish, what to postpone, etc. Is there a tool,
> query, or something that I can run against the job scheduler that will help
> me out?
>
>
>
> Donald Freeman
> Systems Dev Spec, Principle
> ManTech International
> (757)852-6690 (w)
> (717-497-1037 (C)
> (757)-852-7777 PMO-IT Help Desk
> RHR Facility
> donald.freeman_at_mantech.com
> donald.freeman.ctr_at_ablcda.navy.mil
>
>
>
>
>

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

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