COGNOiSe.com - The IBM Cognos Community

Does any body know the name of the batch scripts that run the metric maintenance task for metric studio?

They were pretty easy to find in the previous version but i can't seem to locate them in the new release. Thanks

I figured it out.

Hi Shaud,

Could you let me know what you found out?  I am trying to automate my CMD extracts from batch files.  I would like to know if you have found the correct command line syntax for doing this as well as launching the "Transfer data from staging area into metric store" job from Cognos Connection.  I know how to launch a trigger.bat file that can launch the Schedule with a trigger but I would like to have a bit more control over each job individually.

Thanks.

Steve

Cognos gave us the control to create custom trigger's that will execute any of the metric mainance task indivudially or in any order/ grouping we want. Here's how you can do it.

1.Log into Cognos Connection as an admin.

2.Create a new job in Cognos Connection to run the desired Metric Maintenance task(s).

3.Click on the Schedule icon (under the action column) next to the job link in Cognos Connection.

4.Under Frequency, click on By Trigger.

5.Specify a Start and End time (during this time , if you run the Trigger.bat file, it will be executed).

6.Define a name for the trigger.

After you have created the trigger you may run it however you please, i run mine thru DTS in sql server 2000, but the process is the same if you use a cmd prompt or anything else. here is the syntax to run your trigger (s) from the cmd prompt

c:\..Cognos directory..> Trigger.bat <Gateway URL> <username> <password> <Namespace ID> <comma separated trigger list>