How to Not Start the QV Job refresh, if DB object or source is not available??

[#1]

Hi,

All the Qlikivew Jobs are failing due to some time DB objects are not available, even it leads to QVS crash. Is there a way that, If DB object or data source is not available QV Job refresh should not initiate.

May be it is a tricky question:)

Thanks in advance:):)

[flipside]

Hi,

You can schedule a small .qvw file to run first and have this check DB connection first, THEN schedule the actual documents to refresh only if this "control" document completes successfully (using the 'On event of another task' option on the reload tab).  This might stop your larger reloads failing which appears to be causing your QVS crash.

Hope this helps

flipside