Is there a way to run the Cube build from the command line? STSAD

[mossguy]

Want to know if there is a way to run the cube build, and the AD sync job
from the command line?

This is very strange problem...

I can run the above jobs manuely, but the scheduled job fails... Both using
the same account.

Wanted to see if I can run from the CLI...

Project server 2007 x64, installed on a MOSS 2007 Farm x64

 

[Gary Chefetz]

The issue is most likely the SSP account. There are no STSADM command lines
for firing off the cube build but there's probably a way to do it from
Analysis Services, which I can't help you with. For a complete list and
overview of STSADM commands, see Christophe Fiessinger's blog post
http://blogs.msdn.com/chrisfie/arch...-in-microsoft-office-project-server-2007.aspx

 

[Ray McCoppin]

The ascmd command-line utility enables a database administrator to execute an
XMLA script, MDX query, or DMX statement against an instance of Microsoft SQL
Server 2005 Analysis Services (SSAS). This command-line utility contains
functionality for Analysis Services that resembles the sqlcmd utility
included with SQL Server 2005. For more information, see the topic sqlcmd
Utility in SQL Server 2005. The execution results of the script, query, or
statement can be stored in a file together with relevant SQL Server Profiler
trace information. The default install location for the ascmd command-line
utility is as follows:
<systemdrive_>\Program Files\Microsoft SQL Server\90\Samples\Analysis
Services\Administrator\ascmd

I think it is only installed if you install the code samples. and it maybe
available for download somewhere.

hope this helps
--
Ray McCoppin

Project Server 2007 Archive Tool
Project Server 2007 Publish all projects tool
http://www.randsmanagement.com
SRS gantt charts