August 13, 2010 at 4:31 am
Hello,
I have set up Data Collection on my SQL 2008 server, but it has not collected any data because the collection jobs keep failing. Can anyone assist?
For example, the SQL Agent job "collection_set_1_noncached_collect_and_upload" always fails with this message
Executed as user: XXX\SqlAgentRun. The step did not generate any output. Process Exit Code 5.
The step failed.
XXX\SqlAgentRun is the NT account under which SQL Server agent runs. It is a member of XXX\Domain Users, and is a member of sysadmin.
Thanks in advance.
August 13, 2010 at 7:19 am
Add an output file to the job step to get more details on the failure.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 16, 2010 at 2:04 am
Sorry to thread-jack but I've been getting the same error message recently.
Nothing is being written to the output file I've added.
The Event Log isn't telling me much either
Was running fine until about a week ago
October 27, 2010 at 1:19 pm
Same problem. Same errors and output file is blank.
October 27, 2010 at 9:26 pm
Does running the query inside "collection_set_1_noncached_collect_and_upload" job in SSMS complete successfully?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 27, 2010 at 9:53 pm
It seems this was a issue with SQL Server 2008 SP 1. Issue resolved after installing the Cumulative update package 10 for SQL Server 2008 Service Pack 1.
October 27, 2010 at 11:31 pm
Good to know that it was fixed!
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2011 at 2:42 pm
I received a similiar error when the service running the data collector could not access the cache folder
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply