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.