1. View job History Select TOP [instance_id], [ job_id] , [step_id] , [step_name] , [sql_message_id] , [Sql_severity] , [message] , [run_status] , [run_date] , [run_time] , [run_duration] , [ Operator_id_emailed] , [operator_id_netsent] , [operator_id_paged] , [retries_attempted] , [ Server] from [msdb].[ DBO]. [Sysjobhistory]
2. Review the Maintenance plan log Select TOP [task_detail_id] , [plan_id] , [subplan_id] , [start_time] , [End_time] , [succeeded] , [logged_remotely] , [source_server_name] , [plan_name] , [Subplan_name] From [msdb]. [dbo]. [Sysmaintplan_log]
3. View Maintenance plan log Details Select TOP [task_detail_id] , [line1], [line2] , [Line3] , [line4] , [Line5] , [server_name] , [start_time] , [end_time] , [error_number] , [error_message] , [command] , [succeeded] from [msdb]. [dbo]. [Sysmaintplan_logdetail]
"SQL Server" query maintenance related logs