Using background processing queues

[Chris Kelleher]

I've been trying to establish a background queue to run our MRP at night.
I've been able to create the queue and have the process actually work,
however, when the system was shutdown for backups the queue no longer works.
Has anyone been able to create a batch job to stop and start the queue
service automatically? We are running Syteline 3.5b01a and Progess 8.2C.

Lisa M. Moser
Information Manager
Thos. Moser Cabinetmakers

 

[Chris Kelleher]

All you really need is to get all the bglock.lock-flags shut off before you
restart the queues, every day.

I've written a very simple progress program that I run as part of the script
that kills the background queues processes, just before I shutdown the
databases. All it does is clear the running flag on the bglock table and
change the status on any running job (batchrpt) to Queued, so that it will
restart when the Queues come back up.
I'm running 4.00.02 but I used the same program in SYMIX 3.0.

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each bglock:
bglock.lock-flag = no.
display bglock.queue "Shutdown" with no-label.
for each batchrpt of bglock where batchrpt.stat = "R":
batchrpt.stat = "Q".
display bglock.queue batchrpt.prog-name "will be restarted"
with no-label.
end.
end.

[/code]

Lori Tamburlin
Pure Carbon Company

 

[Chris Kelleher]

You Need to issue a Queue shutdown commmand before doing a database shutdown, or
write a progress program to flip the queue running flag to off after you
start the database servers and before starting the BG queue. A third option
is to manually turn the queue running flag off (MAKE SURE THAT THE QUEUE IS
NOT RUNNING)

As far as a batch job, it is relatively simple to do.

Herb Buehler
LogicData - Los Angeles