Automating cube builds through Windows Scheduler

[jguevin]

maybe the place for this maybe not...

I'm trying to automate through the Task Scheduler and have a simple .bat file which if manually run builds the cube.  I go to schedule it in Windows scheduler and in the schedule log it shows as completing with an exit code of (0) (meaning success).  However the cube does not build.  We only have transformer on this server so starting and stopping ppes is not an issue. The code is...XXX's are user name and password.  I logged in as the user and can manually build the cube in transformer so access is not an issue.  Any thoughts out there??
thanks, Jeff



start "transformer" /w "c:\program files\cognos\cer4\bin\trnsfrmr.exe" -n2 -s -kIHDS_DW01_PROD=XXX/XXX -f\\dwsrv1\cognos\cognos\prod\bin\trnsfrmr_ini.prf -kIHDS_DW01_PROD=XXX/XXX  "\\dwsrv1\cognos\cognos\prod\models\cut_013.mdl"

[Draoued]

I logged in as the user and can manually runÃ, 

tell the scheduler to use the same user to start these jobs , and not the default admin account.

[jguevin]

tried that, still doesn't truly run ( still produces "completed with an exit code of 0").  Created a basic vbscript to create a text file and this batch file runs fine through the scheduler.  Not sure what else to try.

thanks
Jeff

[Draoued]

"c:\program files\cognos\cer4\bin\trnsfrmr.exe" -n2 -s -kIHDS_DW01_PROD=XXX/XXX -f\\dwsrv1\cognos\cognos\prod\bin\trnsfrmr_ini.prf -kIHDS_DW01_PROD=XXX/XXX  "\\dwsrv1\cognos\cognos\prod\models\cut_013.mdl" 

Try this one without the Start transformer /W.

[jguevin]

thanks again,

this runs fine manually, but not through the scheduler.  I get a "run successfully with an exit code of 1" from the windows scheduler log file.

[Draoued]

can you create a batch and run it with the scheduler.

the batch file should read and write to the \\dwsrv1\cognos\cognos\prod\models\  folder .