John Liu Blog

Every drop counts

SQL Agent Maintenance Plan

SQL Agent Maintenance Plan runs SSIS package. When troubleshooting maintenance plan job error, following query might help to view detailed error message as the job history might not contain these information. SELECT TOP 20 * FROM msdb.dbo.sysmaintplan_logdetail ORDER BY start_time DESC;

Posted by John Liu Friday, September 11, 2026

FEATURED TAGS
agent ai api automation availability availability-sets availability-zones aws-vm azure azure-automation-runbook azure-blob azure-cosmos-db azure-data-lake azure-deployment azure-function-app azure-functions azure-openai azure-sign-in azure-site-recovery azure-sql-database azure-subscription azure-vm base64 certificate change-data-capture change-tracking chrome cio-das08 claude-code-desktop clr container cte data-api-builder data-conversion data-gateway database-mail database-role database-size date-table dax db-config deepseek derived-table dfi diagram direct-query disk-management disk-space docker downtime dtc dynamic-m-parameter embedding encrypted-connection excel excel-online excel-online-for-business execution-plan extended-events external-data fabric fabric-capacity failover-cluster fk geometry git hierarchy httpwebrequest hugo hyper-v incognito-mode index infrastructure inline-tvf isa json kql lakehouse linked-server linux live-query-statistics llm-model locking m machine-learning machine-learning-model machine-learning-services maintenance-plan master-key mbatx-cs620-h310c mcp mdx memory memory-grant mermaid mife mirrored-sql-server network network-card network-category office-script onedrive onnx-runtime openrowset p2v parquet performance polybase power-automate power-bi power-bi-report-tricks power-platform power-query powershell printer public-ip-address pyspark python qgis qt-designer query-performance query-plan query-troubleshooting r regex replication route s3 schema-design scripting self-signed-certificate server-role sharepoint snowflake software-development sofware-development spark sql sql-2025 sql-agent sql-availability-group sql-error sql-failover-cluster-instance sql-index sql-openjson sql-permission sql-recovery sql-script sql-security sql-server sql-server-admin sql-server-config sql-statistics ssis ssisdb ssl ssl/tls-error ssms table-expression tempdb terraform tips troubleshooting ubuntu unicode view visual-studio visual-studio-code vm vmware wait-statistics wi-fi-connection-issue win98 windows-settings