January 31, 2011 at 8:02 am
All,
I'm getting the error below when running scheduled Transaction Log & Update Statistics jobs in SQL Agent. Any idea why? I even tried using 'sa' instead of my credential and it still fails.
Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2011-01-30 23:01:47.00 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2011-01-30 23:01:47.06 Code: 0xC0024104 Source: Update Statistics Des... The package execution fa... The step failed.
Any help would be great! Thanks!!! 😀
January 31, 2011 at 9:22 am
Please check the Maintenance Plan history for more information. Here is a screenshot.
Also you can add an output file to the job step which will log the job execution. Here is a screenshot.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply