Return
-
Title
Database Maintenance Screens Hang "Retrieving SQL Job Information" -
Description
Indicator Bar never moves, and there is a message saying "Retrieving SQL Job Information"
-
Cause
We require SQL Client Tools to be present, and the MSSQL Agent to be running on the MessageStats Server in order to Retrieve the SQL Job Information and configure Database Aging and Deletion of Objects in SQL. -
Resolution
If it is not installed, please install the SQL Client Tools.
Once this is complete, ensure that the SQL Agent service is running, and set it to Automatic if it is not set this way already. Close MessageStats if it is running, then reopen the application and try the execute the Database Configuration options again.
If you are seeing this error and are running SQL 2005 please seehttps://support.quest.com/SUPPORT/index?page=solution&id=SOL16718
If you are still having a problem after running either of these solutions for your respective Database version, please contact Quest Support. -
Additional Information
Happens under SQL 2000 all service packs.