View Full Version: Clearing Phantom Jobs From Job Scheduler

LawsonTalk > Member Articles > Clearing Phantom Jobs From Job Scheduler


Title: Clearing Phantom Jobs From Job Scheduler


schroncd - February 10, 2006 05:38 AM (GMT)
How to remove a completed job that sticks in the job queue

You need to change the "Status" field of this particular job from "blank/zero" (active) to 63 (completed). Once the status field is changed the job will move from the Active Jobs screen to the Completed Jobs screen.

There are two ways to accomplish this (actually 3 if you count shutting down and restarting lajs)

1. paint a program against the GEN/QUEUEDJOB table
2. importdb

Using "jqstatus -a" (or 'rngdbdump -ct gen queuedjob -v status=0) you can get the job number for this running job. (The job number is: the third field of 'jqstatus -a', the first field of 'rngdbdump...')

If you have a painted program, use this job number to inquire on the record and update the status to 63

If you use importdb, use "rngdbdump -cnt gen queuedjob -v jobnumber={number} rec.out" to get the record and update the 5th field (status field) to 63. Then use "importdb -a gen queuedjob rec.out" to load the updated record.


A word of caution... make sure you put a valid status value in (63 in this case)... if you fat-finger the value or put in an incorrect one, lajs will probably crash.



Hosted for free by InvisionFree