sqlserver 清除维护相关日志

---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]

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!