May 8, 2012 at 7:21 am
I just setup data collection and now when this job runs I'm getting a failure:
Executed as user: wsdb\sqlagent. The step did not generate any output. Process Exit Code 5. The step failed.
I think 5 is permission denied, but I gave sqlagent full control to the database. I also tried hard coding the servername\instancename in the command and it still fails.
Microsoft SQL Server 2008 (SP2) - 10.0.4311.0 (X64) May 11 2011 14:27:15 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Any other ideas?
May 8, 2012 at 7:37 am
Somehow I came across this http://www.sqlservercentral.com/Forums/Topic968770-391-1.aspx
I tried changing the directory, which was empty to either like d:\jobs or even c:\windows\temp and neither worked. c:\windows\temp actually seemed make other collection set jobs fail.
May 10, 2012 at 6:52 am
I'm still having problems with this. Any hints?
August 17, 2012 at 2:18 pm
So I just ran into this and it turned out to be an issue with the network ID that I was using to run the job. It did not have administrative rights on the server. I am assuming that this stopped the job from running the power shell script. Once I gave the ID admin rights it had no trouble.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply