Post reply

Analysis Services Processing Task Fails when run as Scheduled Job

  • April 6, 2006 at 9:36 am

    #67409

     Hi,

    I have package which Processing olap cube.

    This package works fine when run through Enterprise manager.  But fails if run through a scheduled job. 

    The SQL Server Agent service account is part of the olapadmin group.

    The error I get is "The job failed.  The Job was invoked by Schedule 12 (process_sales_cube).  The last step to run was step 1 (process_sales_cube)."

    I tried to change user and the only thing that changed was the user thar invoked.

    P.S.

    Other packages are runnig with no problem as jobs

    Any ideas on how to solve this problem???

    10X,

    Kupy

  • April 10, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • April 11, 2006 at 2:04 pm

    #631957

    Create a new user that is a member of the olapadmin group and in the DTS package in the Microsoft OLE DB connection when you are in the DTS design view change the connection to use a SQL Account and specifiy the account you created.

    DT

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply