how do i stop a maintenance plan?

Dan,

Does this happen on certain days of the week? If you knew what caused it to
run longer you could schedule differently.

Chris

"Dan Holmes" wrote in message

>I have a maintenance plan that runs every night. Sometimes it takes too
>long to run and it affects production for the following morning. I can see
>and kill the process it is currently running but then the next task starts
>and i have to kill that too. How can i stop the thing once it has started?
>
> thanks
>
> sqlserver 2005
 >> Stay informed about: how do i stop a maintenance plan? 

Dan,

This is a bit of a sledge hammer but....

You could also get a list of running jobs at 6:00 AM (pick your target
time here), if any of the jobs are the ones created by the maint plan,
then execute a sp_stop_job against it. It will finish up the last
piece it was working on but then should die. if you had to you could
just execute a sp_stop_job for each of the jobs in the maint plan.
Not sure if it will fail or jot if the job is not running. Test test
test!

http://msdn.microsoft.com/en-us/library/aa260308%28SQL.80%29.aspx

my 2 cents!

David Hay

On Mar 11, 9:38 am, Dan Holmes wrote:
> I have a maintenance plan that runs every night.  Sometimes it takes too long to run and it affects production for the
> following morning.  I can see and kill the process it is currently running but then the next task starts and i have to
> kill that too.  How can i stop the thing once it has started?
>
> thanks
>
> sqlserver 2005
 >> Stay informed about: how do i stop a maintenance plan? 

Dan Holmes (dan.holmes@routematch.com) writes:
> I have a maintenance plan that runs every night. Sometimes it takes too
> long to run and it affects production for the following morning. I can
> see and kill the process it is currently running but then the next task
> starts and i have to kill that too. How can i stop the thing once it
> has started?

Maybe you should review what the Mgmt Plans are doing altogether? Are
you rebuilding too many indexes? You are not shrinking databases, I hope?

--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: how do i stop a maintenance plan? 

> Maybe you should review what the Mgmt Plans are doing altogether? Are
> you rebuilding too many indexes? You are not shrinking databases, I hope?

+1

--
Jay Konigsberg
SQL Server DBA in Sacramento, CA
http://www.linkedin.com/in/jaykonigsberg

Live in Sacramento, CA?
Join the Sacramento SQL Server User Group on LinkedIn
http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg



"Erland Sommarskog" wrote in message

> Dan Holmes (dan.holmes@routematch.com) writes:
>> I have a maintenance plan that runs every night. Sometimes it takes too
>> long to run and it affects production for the following morning. I can
>> see and kill the process it is currently running but then the next task
>> starts and i have to kill that too. How can i stop the thing once it
>> has started?
>
> Maybe you should review what the Mgmt Plans are doing altogether? Are
> you rebuilding too many indexes? You are not shrinking databases, I hope?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
 >> Stay informed about: how do i stop a maintenance plan? 

+1

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Jay Konigsberg" wrote in message
news:#S9Gp6WwKHA.1796@TK2MSFTNGP02.phx.gbl...
>> Maybe you should review what the Mgmt Plans are doing altogether? Are
>> you rebuilding too many indexes? You are not shrinking databases, I hope?
>
> +1
>
> --
> Jay Konigsberg
> SQL Server DBA in Sacramento, CA
> http://www.linkedin.com/in/jaykonigsberg
>
> Live in Sacramento, CA?
> Join the Sacramento SQL Server User Group on LinkedIn
> http://www.linkedin.com/groups?home=&gid=2825448&trk=anet_ug_hm&goback=%2Emyg
>
>
>
> "Erland Sommarskog" wrote in message
>
>> Dan Holmes (dan.holmes@routematch.com) writes:
>>> I have a maintenance plan that runs every night. Sometimes it takes too
>>> long to run and it affects production for the following morning. I can
>>> see and kill the process it is currently running but then the next task
>>> starts and i have to kill that too. How can i stop the thing once it
>>> has started?
>>
>> Maybe you should review what the Mgmt Plans are doing altogether? Are
>> you rebuilding too many indexes? You are not shrinking databases, I hope?
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se
>>
>> Links for SQL Server Books Online:
>> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
>> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
>> SQL 2000:
>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>>
>
>
 >> Stay informed about: how do i stop a maintenance plan? 

Agreed. Maintenance plans should be avoided and you should control
everything that you MIGHT want/need to do with them using TSQL scripts and
Agent jobs. A quick engagement with a consultant can get you where you need
to be in short order. Or Ola Hallengren has a WONDERFUL collection of free
TSQL scripts that you can use to control all major maintenance activies.
http://ola.hallengren.com/

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Erland Sommarskog" wrote in message

> Dan Holmes (dan.holmes@routematch.com) writes:
>> I have a maintenance plan that runs every night. Sometimes it takes too
>> long to run and it affects production for the following morning. I can
>> see and kill the process it is currently running but then the next task
>> starts and i have to kill that too. How can i stop the thing once it
>> has started?
>
> Maybe you should review what the Mgmt Plans are doing altogether? Are
> you rebuilding too many indexes? You are not shrinking databases, I hope?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
 >> Stay informed about: how do i stop a maintenance plan?