CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Scheduler tables

edited Jun 3, 2015 7:03AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

I understand there are two Scheduler tables: F91300 and F91320.

The F91300 table has rows with the status SJSCHJBSTAT which indicates to the server whether the job is either active (01) or inactive (02).

I'm looking for a way to somehow start the schedule I have established based off of an external event.

I know this is most likely not recommended but would it work if I had a SQL procedure that could find the appropriate schedule row(s) in the Schedule Job Master table and change the SJSCHJBSTAT field from 02 to 01 in order for the server to 'see'

that a job is active and should schedule it at the appropriate time?

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