Am I able to update a sequel server table with the date and time a QVW was last reloaded and show any failures?

[gavin_kite]

I'd like to find out if anyone has managed to output to Sequel Server various info from the QMC such as QVW name, the last reload time and date, If it failed to load etc. We have a monitoring/alert dashboard (not Qlikview) that sits over this Sequel Server table that monitors other BI applications and we'd like to add Qlikview to it.

Thanks

[marcus_malinow]

You could use a stored procedure to do this, perhaps by feeding in the date of the reload start, and then when the reload has completed, the date of reload completion. Then, your failures will show up as those records without a reload completion.

In order to execute a stored proc use this syntax:

SQL EXEC StoredProcedureName $(VariableName);

You'll need to use an ODBC connection to execute a stored proc. I don't believe this is possible using OLE DB.

[kaushiknsolanki]

Hi,

     You can use the different logs generated by QlikView.

     Like the task logs, event logs, session logs

Regards,

Kaushik Solanki