CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Scheduled jobs suspension

edited Apr 1, 2011 1:11AM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered
 At customer site I need to implement  a job suspension.
For example a list of jobs that run every 30 minutes need to be suspended from 14:00 to 16:00.

Updating job scheduler table to make inactive the job is not sufficient because in order to restart the jobs new records need to be inserted in F91320 table (as the next new occurrences of the jobs).

I'm sure I can accomplish this developing a custom report or function with the same logic of the scheduler application but a requirements is to be able to execute the suspension outside JDE (sql script is an option).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center