Does anyone know if the set-up options/schedules for a datbase maintenance plan(optimization, back-up, integrity, etc) are stored in a table somewhere in the datbase? I want to be able to define a query that pulls maintence plan information. For example I want to query a database and see if the "back up the database as part of the maintenance plan" is checked and the scheduled time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
WHERE IS MAINT PLAN INFO STORED IN DB????
- Thread starter jrc1
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question