Cleaning out the System and Task Status Log

There are many entries listed in the System Tasks Status log, viewed from the system administrator panel. Deleting them manually takes far too long, and entries in "error" status cannot be deleted at all.

In the performance report on Unix platforms, the "get_next_task" procedure shows up as using significant database resources.

Connect to BB60 Database and execute the following command:

DELETE FROM queued_tasks WHERE status IN ('C','E') AND end_date < sysdate-7;

COMMIT;