Post reply

execute process task

  • January 16, 2009 at 1:14 pm

    #130071

    I have an 'execute process' task as part of a package which starts a Cognos report (C:\Program Files.....runmac32 Z:\Macros\somereport.mac). It runs just fine out of BIDS, but when the job is scheduled with SQL ServerAgent, I get the following error: The directory "Z:\MACROS" does not exist". SQL Server agent is set up to log in as an account that I know for sure has access to that folder. I also tried using a proxy account, that didn't work. Any suggestions, please? Thanks!

  • January 16, 2009 at 1:19 pm

    #928487

    Is the "Z" drive on the server or is it a mapped drive on another machine?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • January 16, 2009 at 1:51 pm

    #928506

    Yes - and I just tried using the UNC instead, and it worked! (someone suggested it). I wonder how I didn't think of this myself... But it works now, thanks!!

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

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