🔧 Maintenance Plans

Automated database maintenance and optimization

12
Active Plans
3
Running Now
98%
Success Rate
24
Tasks Today
4.2h
Avg Duration

📋 Maintenance Plans

🗄️ DBAOps_DailyMaintenance - Production
✓ Active
✓ Integrity Check ✓ Index Rebuild ✓ Statistics Update ✓ Cleanup History ✓ Log Shrink
📍 PROD-SQL-01, PROD-SQL-02, PROD-SQL-03 ⏰ Daily at 02:00 ✅ Last run: Success (45m 12s)
📊 IndexOptimize - Weekly
✓ Active
✓ Reorganize (5-30%) ✓ Rebuild (>30%) ✓ Update Statistics
📍 All Production Servers ⏰ Sunday 03:00 ✅ Last run: Success (2h 15m)
🗃️ DatabaseIntegrityCheck - Weekly
✓ Active
✓ CHECKDB ✓ CHECKCATALOG ✓ CHECKALLOC
📍 All Servers ⏰ Saturday 01:00 ✅ Last run: Success (3h 45m)
🧹 HistoryCleanup - Monthly
📅 Next: Mar 1
✓ Backup History (90 days) ✓ Job History (60 days) ✓ Maintenance History (90 days)
📍 All Servers ⏰ 1st of Month 00:00 ✅ Last run: Success (15m)
📦 ShrinkDatabase - Manual
◯ Disabled
Shrink Data Files Shrink Log Files
📍 As needed ⏰ Manual trigger only ⚠️ Use with caution

🔄 Currently Running

🔄
Index Rebuild - Orders table
PROD-SQL-01 • ECommerce database
12m 34s
📊
Statistics Update
PROD-SQL-02 • Inventory database
5m 22s
✓
CHECKDB
ORACLE-HR • HR_DATA tablespace
28m 15s

📅 Upcoming Tasks

🌙
DBAOps_DailyMaintenance
Production servers
Tonight 02:00
📆
DatabaseIntegrityCheck
All servers
Saturday 01:00
📆
IndexOptimize - Weekly
All production
Sunday 03:00