Using Cognos Scheduler V7.0.16.0

[qmthales]

Hi - I use Cognos Scheduler (V7.0.16.0) to run data extractions via Impromptu V 7.809.0 and to deposit the data in dbf format. It works a treat. The problem I have is that each report leaves an instance of the application and a session running, which usurps resources extensively. I have noticed in the scheduler a command script option, and am hoping some clever person can give me a magic script that will close the session (of Impromptu) at the end of the export cycle and prior to the next scheduled task. Thanks in anticipation

 

[navshiv]

Do you run a macro to do this extract or does the scheduler run the report itself? If it's a macro can you not include objImpApp.Quit at the end?

Or you could use the Windows Kill command to kill the Impadmin.exe process?

 

[elalacran]

You could try this macro ...


Sub Main()

Dim objImpApp As object
Set objImpApp = GetObject("CognosImpromptu.Application")
objImpApp.Quit
Set objImpApp = Nothing

End Sub