Notes

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======Using the Windows Scheduler to schedule an Impromptu macro (on a server)=====
From [[http://pcnorb.blogspot.com/2010/02/allscripts-tiger-to-ms-sql-to-godaddy.html|John Croson's Blog Home - AllScripts Tiger to MS SQL to GoDaddy Hosting]]: \\
"The workstation running the reports must have a user logged in with the Cognos Scheduler application running in order to fire the reports off. It cannot run via the Windows Scheduled Tasks"

**DOESN'T WORK, YOU GET A "FAILED TO INITIALIZE" MESSAGE FROM runmac32.exe** \\
I ran into this same problem when trying to schedule an Impromptu macro with runmac32 under a normal user account. It seems that the problem is caused by the scheduled task not loading a full userprofile when executing. Unfortunately Impromptu seems to need a fully loaded profile to even start.

As I couldn't find a way to force the scheduled task to load a full userprofile, I worked around the problem by creating an encrypted job file with [[http://www.joeware.net/freetools/tools/cpau/index.htm|CPAU]] and then scheduling CPAU with the encrypted job file in a scheduled task with the -lwp option that forces the job that gets started by CPAU to load a full profile for the configured user.

Create encrypted job file to run command under the defined user:
<code>
CPAU.exe -u Domain\Macro -p password -ex "\"C:\Program Files\Cognos\cer5\bin\runmac32.exe\" \"\\fileserver.domain.local\software\Impromptu\Macro.mac\"" -enc -file macrojob.jb -lwp
</code>

Schedule the following command in a Windows scheduled task:
<code>

CPAU.exe -dec -file macrojob.jb -lwp -hide
</code>
Provide full paths to the .exe and .jb where appropriate. \\
**DOESN'T WORK, YOU GET A "FAILED TO INITIALIZE" MESSAGE FROM runmac32.exe** \\