Blackboard Learn 9.0.613.0 has initiated multiple concurrent Jobs every 10 mins calling the same Stored Procedure activity_accumulator_update
Any ideas or suggestions please .... we should have one Job here right ... ?
Oracle - DBA_JOBS
49 BB_BB60 07_NOV-2011 17:31:58 07-NOV-2011 17:41:58 sysdate+1/24/6 activity_accumulator_update;
70 BB_BB60 07_NOV-2011 17:31:58 07-NOV-2011 17:41:58 sysdate+1/24/6 activity_accumulator_update;
77 BB_BB60 07_NOV-2011 17:31:58 07-NOV-2011 17:41:58 sysdate+1/24/6 activity_accumulator_update;
90 BB_BB60 07_NOV-2011 17:31:58 07-NOV-2011 17:41:58 sysdate+1/24/6 activity_accumulator_update;
99 BB_BB60 07_NOV-2011 17:31:58 07-NOV-2011 17:41:58 sysdate+1/24/6 activity_accumulator_update;
Thanks
Steve
Stephen,
The activity_accumulator_update job transfers records from the small activity_accumulator_queeu table to the long-term activity_accumulator table. Have a look at some of the discussion from July 2009 at the end of the KB article http://kb.blackboard.com/display/KB/The+PurgeAccumulator+Task -- it looks like the installer can wind up creating multiple versions of the job, at least on Oracle.
However, if you're not seeing stats getting added to the activity_accumulator table, that's a problem. There are instructions on how to fix it, as well as how to clear out the duplicate scheduled jobs, at http://kb.blackboard.com/display/KB/The+aa_update_bb_bb60+Job+is+not+Adding+Data+to+the+Activity+Accumulator
Mike
Thanks Michael for the prompt feedback. I will take a look and update this thread ...