We have many DeskI reports scheduled to refresh every night. Now we need some way of knowing which of them where ended with “No data to fetch”, as we need to make some corrective actions.
Is there a way to send some acknowledgement on successful jobs, which returned no rows (without looking into every single instance manually?)
mooci (BOB member since 2007-02-16)
As suggested, you can add this functionality to a document with VBA code. Not ideal, because you would have to add the code to each document itself, and you would have to code the actual recording of the event as well, but it would work. See a similar discussion here … VB code to capture No Data to fetch message while refreshing.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)