Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2014-01-19 : 15:47:21
|
| Good afternoon, i need your helpIn mot a DBA, just i see some procesees running in sqls erver 2008, those processes are triggered by Manteninace Plan tool in SSMS.Ive got some questions:1. Is there any way to view or list previous executions so that i could know duration times for a running Manteinance process ?2. In SMSS can i see the state of a running process ? running - idle, etc3.so is there any way to stop or start a manteinance plan in SSMS ?Thanks for your help in advanced |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2014-01-21 : 13:41:40
|
| You can view the history of maintenance plans - open the Maintenance Plan folder in Object Explorer and right-click the plan. Select View History and you can view the history.Each maintenance plan also has an agent job, you can stop/start the agent job as needed - however I would not recommend canceling the job.To see what is running on your system you can use Activity Monitor. |
 |
|
|
|
|
|
Manteinancedb PLan Overview