sqlserver 清除维护相关日志转

iteye_14608

于 2013-04-22 13:09:00 发布

阅读量121

点赞数

文章标签：数据库

本文详细介绍了如何使用SQL查询语句查看数据库的历史记录、维护计划日志及日志详情，包括作业历史记录、维护计划操作等关键信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

---1.查看作业历史记录

SELECT TOP 1000 [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]

delete from [msdb].[dbo].[sysjobhistory]

---2.查看维护计划日志

SELECT TOP 1000 [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]

delete from [msdb].[dbo].[sysmaintplan_log]

---3.查看维护计划日志详情

SELECT TOP 1000 [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]

delete from [msdb].[dbo].[sysmaintplan_logdetail]