Find Answers

Filter Search Results

Ask a Question

Example: "Database could not be verified"

Results

How to clear an Application Repository activity that is hung in a Waiting status

Attempting to cancel or delete the jobs stuck in Waiting doesn't do anything and requires you to run an update query against the Application Repository database. In the Application Repository database look in the QRTZ_ACTIVITY table. Identify the row in question and change the Status column to 2. (For example, if the row has a TS_ID of 5, you can run this statement: UPDATE QRTZ_ACTIVITY SET STATUS = 2 WHERE TS_ID = 5)

Computing Statistics for Table Indexes.txt

------------------------------- ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY _LOG COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE TABLE SAMPLE. QRTZ_ACTIVITY _PARAM COMPUTE STATISTICS FOR ALL INDEXES; ANALYZE

TeamTrack Database Schema

Described below.  QRTZ_*: Tables used by SBM Application Repository for scheduling engine. QRTZ_ACTIVITY QRTZ_ACTIVITY _LOG QRTZ_ACTIVITY _PARAM QRTZ_BLOB_TRIGGERS QRTZ_CALENDARS QRTZ_CRON_TRIGGERS QRTZ_FIRED_TRIGGERS QRTZ_JOB_DETAILS QRTZ_JOB_LISTENERS QRTZ_LOCKS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_SCHEDULER_STATE QRTZ_SIMPLE_TRIGGERS QRTZ_TRIGGERS QRTZ_TRIGGER_LISTENERS  CL_*: Tables used by Common Logger to log system messages.

Knowledgebase

Find Answers

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance