Thursday, May 1, 2014

Moving the Job Scheduler to another server


The situation is you've decided to move to JDE job scheduler to another server. The steps below provide a process to expedite said move.
 First we need to make sure no servers are running the scheduler. To do this first hack the F91300 table:

Update sys900.f91300 set sjschjbnm=’**SCHEDULER’ where sjschjbnm=’*SCHEDULER’

Next change two tables, F91300, F91320 to the new scheduler server:

Update sys7900.f91300 set sjschjobsvr=’newservername’ where sjschjobsvr=’newservername’

Update sys900.f91320 set jslndatp=’newservername’ where jslndatp=’oldservername’

Change the F91300 back to the original user for *scheduler:

Update sys900.f91300 set sjschjbnm=’*SCHEDULER’ where sjschjbnm=’**SCHEDULER’

320

Start the services back up and verify the scheduler server comes up clean.
Set up a one time scheduler job and verify it fires to the new scheduler server.

No comments:

Post a Comment

Featured Post

Generate single index on table 

Transaction tables such as F0911, F4111 etc hold a huge amount of data probably a third of petabyte. Generating indexes on such tables (th...

Popular Posts