August 15, 2012 at 10:45 am
hello
I schedule job using Maintainance plan
but toy it fails and error log is
Argument "Local" for option "connection" is not valid. The command line parameters are invalid. The step failed.
so please let me know, how to handle this
August 15, 2012 at 11:58 am
You'll need to verify the command line parameters of the plan, as per the error.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 15, 2012 at 12:42 pm
GSquared (8/15/2012)
You'll need to verify the command line parameters of the plan, as per the error.
I Think
command is fine
/SQL "Maintenance Plans\MaintenancePlan"
/SERVER "SERVERNAME"
/CHECKPOINTING OFF
/SET "\Package\Subplan_1.Disable";false
/REPORTING E
August 15, 2012 at 2:35 pm
What is the actual value for the /SERVER parameter, where you have "SERVERNAME"? Are you using Local, or "."? Or is it possibly on a clustered instance and you have one of the host nodes there instead of the cluster name?
August 15, 2012 at 2:51 pm
tim_harkin (8/15/2012)
What is the actual value for the /SERVER parameter, where you have "SERVERNAME"? Are you using Local, or "."? Or is it possibly on a clustered instance and you have one of the host nodes there instead of the cluster name?
For Server Name it will be local server name what i am getting from this t-sql
select convert(nvarchar(128), serverproperty('servername'));
on one more thing also,
when i check connection in Maintainance Plan, its there as Local Connection manager.
but when i check in job property in Data source, there is no any connection.
so can you please suggests me how to add connection in Data Source in job property.
OR do i need to recreate the maintenance plan?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply