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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2009-05-29 : 03:53:33
|
| has anyone encountered a problem with maintenance jobs created on one VCS node, which properties can't be opened or displayed but the jobs run....then when failed over to the other node, the jobs don't run at all?The system where I've encountered this is in an active/passive VCS, MSSQL2005 x64 Standard SP2.any help appreciated.--------------------keeping it simple... |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2009-05-29 : 04:58:40
|
| For anyone who's interested...I gave up yesterday about the issue since there were two avenues to check:1. virtual server name was too long (but googling tells me that there is 128 character limit on the name so this shouldn't be an issue)2. the installation drive has been changed, I suspected it was a disk signature of some sort (in VCS you install stand-alones and then let VCS cluster the services so only one server or instance is up) - but that is not the case now, I tried to run the jobs after failing over and they work on both nodes - which is like the proverbial, wait and see if it makes any difference (weird but I've accepted that fact since waiting usually works...probably some update, but I reinstalled 3x! and always the same setup and steps...)This leads me to the conclusion that it is a GUI problem, the message is the usual "string will be truncated" when the character limit is met..and this only shows up when clicking on Properties for the job or maintenance plan, also when deleting the maintenance plan via GUI.I checked the system tables where target server information and maintenance plan properties are saved and I can't see any character limit reached there...But if someone does have an explanation, any information is very most welcome...--------------------keeping it simple... |
 |
|
|
|
|
|
Maintenance plan and VCS