Technical FAQs

Ask a Question

EEM - How to retrieve Database Loader Run History Information

Issue
When troubleshooting the ION Database Loader, it may be necessary to view the run history to see if there are significant changes in run duration over time. 

Product Line
ION EEM

Environment
SQL Server Management Studio

Resolution

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*


There is a table in the EEM database called dbo.ADA_AdapterRun. This table contains all of the run history of the ION Database Loader, including start time, stop time, number of configured Source Measurement Pairs, and number of records imported. 

The attached query can be run to provide more meaningful information such as Run Duration (in minutes). 

 
Was this helpful?
What can we do to improve the information ?