maintenace plan progress

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

bryan van ritter (5/3/2010)
Hi,
Is there a way to query the progress of a maintenance plan?
bryan

What exactly you want here ? elaborate your requirement.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

bryan van ritter SSCrazy Points: 2270 More actions · Answer 2

When i start a maintenanceplan if it's scheduled or not i want to be able to see the ETA of the plan.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

these are the tables present in msdb

use msdb

go

select top 2 * from sysmaintplan_logdetail

select top 2 *from sysdbmaintplans

select top 2* from sysmaintplan_log

select top 2* from sysmaintplan_subplans

select top 2* from sysdbmaintplan_history

select top 2* from sysdbmaintplan_databases

select top 2* from sysdbmaintplan_jobs

and what do you mean by ETA ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

bryan van ritter SSCrazy Points: 2270 More actions · Answer 4

SSCrazy

Points: 2270

May 3, 2010 at 5:22 am

Thanks for the hint

ETA: Estimated time of arrival