« SWBRDT* reports | Main | Garden 2012 »
September 14, 2012
SWRRSC2
We had problems with the job swrrsc2 (student schedule print job). It was using too much redo space in Oracle. The job runs every minute and sweeps a collector table. It also was being called from gjajobs.shl which creates an entry in the job table. I changed the schedule for the job so it only runs Monday - Friday at 7am-5pm and I rewrote the script so that it doesn't use gjajobs.shl to run. Hopefully this will help.
Posted by soukupm at September 14, 2012 4:33 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)