Maintaintance plan error

I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
Rupesh
It looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:

> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh
|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
[vbcol=seagreen]
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:

Maintaintance plan error

I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
RupeshIt looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:
> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:
> > I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> > am creating new maintainance plan ,at the end when i click finish button of
> > the wizard,message i am getting is "one or more arguments are invalid",please
> > reply me what is the problem asap.
> >
> > Thanks
> > Rupesh

Mail service Error

I have a SQL Server 2000 with Service Pack 3. I have job
that is hung on a step that tries to stop the mail (using
xp_stopmail command) service. The Status says Executing
for the last day.
What could cause the mail service to not be able to stop
when using xp_stopmail or not to start when using
xp_sendmail?
Also, how can I reset this without restarting the server?
I had the same issue a few weeks ago and tried to stop the
mail service but couldn't
I then tried to stop the Agent, thinking restarting the
agent would release the lock. But then the agent wouldn't
restart, so I had to restart the Server to get things
working.
Thanks
DonHave seen the exact same problem occasionally before. The problem was only
fixed after restart SQL server. It was likely caused by problems on the
Exchange server side.
Richard
"Don" <dons100@.yahoo.com> wrote in message
news:4ce701c3ffc1$ac2df590$a401280a@.phx.gbl...
> I have a SQL Server 2000 with Service Pack 3. I have job
> that is hung on a step that tries to stop the mail (using
> xp_stopmail command) service. The Status says Executing
> for the last day.
> What could cause the mail service to not be able to stop
> when using xp_stopmail or not to start when using
> xp_sendmail?
> Also, how can I reset this without restarting the server?
> I had the same issue a few weeks ago and tried to stop the
> mail service but couldn't
> I then tried to stop the Agent, thinking restarting the
> agent would release the lock. But then the agent wouldn't
> restart, so I had to restart the Server to get things
> working.
> Thanks
> Don

Mail service Error

I have a SQL Server 2000 with Service Pack 3. I have job
that is hung on a step that tries to stop the mail (using
xp_stopmail command) service. The Status says Executing
for the last day.
What could cause the mail service to not be able to stop
when using xp_stopmail or not to start when using
xp_sendmail?
Also, how can I reset this without restarting the server?
I had the same issue a few weeks ago and tried to stop the
mail service but couldn't
I then tried to stop the Agent, thinking restarting the
agent would release the lock. But then the agent wouldn't
restart, so I had to restart the Server to get things
working.
Thanks
DonHave seen the exact same problem occasionally before. The problem was only
fixed after restart SQL server. It was likely caused by problems on the
Exchange server side.
Richard
"Don" <dons100@.yahoo.com> wrote in message
news:4ce701c3ffc1$ac2df590$a401280a@.phx.gbl...
> I have a SQL Server 2000 with Service Pack 3. I have job
> that is hung on a step that tries to stop the mail (using
> xp_stopmail command) service. The Status says Executing
> for the last day.
> What could cause the mail service to not be able to stop
> when using xp_stopmail or not to start when using
> xp_sendmail?
> Also, how can I reset this without restarting the server?
> I had the same issue a few weeks ago and tried to stop the
> mail service but couldn't
> I then tried to stop the Agent, thinking restarting the
> agent would release the lock. But then the agent wouldn't
> restart, so I had to restart the Server to get things
> working.
> Thanks
> Don