Hello,
I'm trying to execute SAS Stored Macros from the Excel with VBA. Have sometimes failures of the listeners and couldn't really anderstand when it happends and what is the source of the problem, but usually when the SAS server is slow and I have a message that 'OLE is waiting fo SAS answer' on the other hand sometimes even having this message everything goes fine.
How could i control the listener health? The problem is that I set up a loop checking if the execution is finished and having no answer from SAS make the loop endless and I don't know what is going on, cause when I check SAS processes are competed and everything went fine just I didn't get the event. It is the same On _StepError and _SubmitComplete listeners.