September 30, 2010 at 8:41 am
Hi all,
I'm trying to create a package using VS 2008 to transfer all jobs between production and DR on a regular basis (both SQL 2005 x64). The problem I have is that it keeps failing on a job related to replication, stating;
"The specified '@Server' is invalid (valid values are returned by sp_helpserver)"
Does anyone know how I can get this job to transfer or alternatively give me some guidance on a way to exclude this particular job from the task ?
I don't really want to specify a JobsList as this would require regular maintenance for any new jobs added to the server.
Any help would be greatly appreciated!
October 1, 2010 at 4:55 am
I've just had a look through the other forums and I've re-posted to one more relevant to my question.
October 1, 2010 at 5:02 am
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic996529-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply