If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Automating the optimization task

Started by treadltly, 08 Jan 2009 08:58:28 AM

Previous topic - Next topic


We recently implemented Controller and currently have to manually run the optimization task twice per monthly cycle. I was wondering if anyone knew of a way to run the optimization task via script or a command line batch job.  Or is it something that the Oracle DBA's could do outside of the application?

Thanks in advance,



Yes, as described in page 102 of the Controller install guide (on the server).
C:\Program Files\Cognos\c8\webcontent\documentation\en\ctrl_inst.pdf


Thanks, mine wasn't on 102, but I did find it in the document.

Thanks for your help.



I realise that this topic is old, but hopefully the information below is useful to someone!  :)

Database server best practices are in my Technotes here:However, I suspect that you are interested in scheduling/automating an 'internal' (application) database optimise. This is not possible.