Maintenance Plan Info - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Maintenance Plan Info

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2009-10-05 : 09:38:40

Hi,

Where can i find information on my Maintenance Plans ( i mean what table is it stored in).

i need to know Plan names histoyr etc etc.....

cheers

Pete

Kind Regards

Pete.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-05 : 13:35:48

The info is stored in the msdb database. Check the system tables in that database to figure out which tables you'll need.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources