Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
  Results
CMS-XML 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)
CMS-XML SBM: About the "Clear History" feature used to schedule Common Log cleanup (Delete Common Logger)
to_date('1970-01-01','YYYY-MM-DD')+TIME_START_NEXT/86400000 as NEXT_START, STATUS from QRTZ_ACTIVITY where NAME = 'ClearCommonLogJob' SQL Server:

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs