April 1, 2012 at 6:28 am
hi Team
My job is failed due to below reason :
Message
Executed as user: xxx . Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) The statement has been terminated. [SQLSTATE 01000] (Message 3621). The step failed.
Please let me know root cause ..
April 1, 2012 at 7:42 am
No way to know that for sure based on what you provided. It could be almost anything. Look to see if you have errors before this one. Also, if you have output from the job, check that output. If you don't have output from your jobs, I'd recommend setting that up. It's frequently the only way to understand what went wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply