SQL Server Agent Executed as user: domain\user. Warning: cannot write a log to table. The step

  • Trying to process a dimension via the agent using the following script:

    IDR_IDEAR_WAREHOUSE

    Academic Year

    ProcessUpdate

    UseExisting

    get error:

    Executed as user: domain\user. Warning: cannot write a log to table. The step failed.

    Don't think its to do with the user permissions as I've tried domain members of the admin group. Any suggestions please.


    Phil Nicholas

  • This was removed by the editor as SPAM

  • Its a bit late for this post but I have a similar problem.

    It seems to happen when I schedule OLAP processing through SQL Agent processing xmla commands.

    I can work around it by not selecting log output to table or include output in job history on the advanced tab of the agent job step editor.

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

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