Cognos Event Agent Job on Hold or Doesn't work due to "LOCK" resource

Clean up the NC tables by performing the following steps:
1) Stop the Cognos services
2) Execute the following sql against the Notification store data
base:
ﾠ
TRUNCATE TABLE NC_TASK_ANCESTOR_STOREIDS;
TRUNCATE TABLE NC_TASK_HISTORY_DETAIL;
TRUNCATE TABLE NC_TASK_PROPERTY;
TRUNCATE TABLE NC_TASK_QUEUE;
TRUNCATE TABLE NC_TSE_STATE_MAP;
TRUNCATE TABLE NC_RESOURCE_LOCK;

3) Start Cognos services back up