Data Collection jobs keep failing

  • EITCL

    SSCrazy

    Points: 2301

    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.

  • Adiga

    One Orange Chip

    Points: 27224

    Add an output file to the job step to get more details on the failure.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Joseph Fallon

    SSCommitted

    Points: 1669

    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

  • mkrawats

    SSC Enthusiast

    Points: 118

    Same problem. Same errors and output file is blank.

  • Adiga

    One Orange Chip

    Points: 27224

    Does running the query inside "collection_set_1_noncached_collect_and_upload" job in SSMS complete successfully?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • mkrawats

    SSC Enthusiast

    Points: 118

    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.

  • Adiga

    One Orange Chip

    Points: 27224

    Good to know that it was fixed!

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • SQLGuy64

    Ten Centuries

    Points: 1051

    I received a similiar error when the service running the data collector could not access the cache folder

Viewing 8 posts - 1 through 8 (of 8 total)

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