September 21, 2010 at 10:35 am
Hi Friends,
i have created a new maintanence plan and set the subplan under that, and schdeuled it properly,
When the plan got executed it was running the plan 2 times with in a min and i am getting the report for twice. i have rechecked everything but Help.
Can any help me out this Maintanenceplan rerunning twice.
Very urgent
Thanks a lot
jak
I have seen such error in 2005 but they told its a bug in sql server. now i am working on 2008 Enterprise edition.R2 idntnhink there is a prblm with this.
@JayMunnangi
September 21, 2010 at 11:13 am
Is this in cluster? If so, check if SQL agent service for your instance running on both nodes.
September 21, 2010 at 12:03 pm
Nope its not a cluster machine, Its a Central Replication Server.
@JayMunnangi
September 22, 2010 at 12:08 pm
You can try to look at the associated SQL Agent job that gets created and see what the schedule is configured to.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
September 23, 2010 at 11:29 am
Could you please attached the screen shot of the main and subplan screen shot as well job properties.
Regards,
Subbu
Click here to Get Speedy answer or solution
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply