Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-04-19 : 00:16:55
|
| Hello All,The Maintenance Plans on the Server all of sudden stopped neither there is no evidence in the ERRORLOG or Maintenance Plan log writer.It simply failed and there is nothing can be expressed to tell.I have checked its execution manually but it says PERFORMING COMPLETION ACTION and there is no success of that.Can anyone help me in this regard.Much thanks to all who are a constant inspiration. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-19 : 04:02:13
|
| stop and restart your SQL Server Agent services.--------------------------http://connectsql.blogspot.com/ |
 |
|
|
keithar2001
Starting Member
3 Posts |
Posted - 2011-04-20 : 18:25:18
|
| Check Windows Services to see what account is being used by the SQLServerAgent service. If it is using a user account then check to see if the password has been changed. If the password was changed in Active Directory Users and Computers then it is likely that the account has been locked out. Enable the account and update the password used to start the service.Keith RobertsNetwork AdministratorHometown Bank |
|
|
|
|
|
|
Maintenance Plan