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 2000 Forums
 SQL Server Administration (2000)
 query maintenance plans?

Author  Topic 

rb1373
Yak Posting Veteran

93 Posts

Posted - 2004-10-27 : 11:53:41
Is there a way to query maintenance plans? sp_help_maintenance_plan isn't returning the information I desire.

Desired results would be:

plan name, DB backup path, DB remove files older than x, log backup path, log remove files older than x, email report

Thanks.

- ray

Server Server 2000 SP 3

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-27 : 13:04:36
Check out the sysdbmaint* tables in msdb database. And here's an alternative to using maintenance plans (check out the comments as well):

http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Tara
Go to Top of Page
   

- Advertisement -