dbTalk Databases Forums  

Re: Unable to Process Cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Unable to Process Cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sven Sohrweide
 
Posts: n/a

Default Re: Unable to Process Cube - 09-17-2003 , 05:34 PM






Maybe an account problem?

Under which acccount runs the SQl AGENT (usually SYSTEM)
Change the account of SQL Agent (in Properties Tab - General) to a user
belonging to the OLAP Administrators group or put SYSTEM into the group..

Greetinx

Sven

"Kiran Kumar" <vcavaturu (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:eLZYHjWfDHA.1888 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
Hi All,

I am unable to process cube through SQL job. I am processing the
cube through DTS package. Inside the Dts
package I am using Analysis service processing task. DTS package
executes fine and process the cubes. When I call
this dts package from a SQL Job using dtsrun command the sql job
fails.

Can you help me

Thanks,
Kiran





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.