sqlserver 清除维护相关日志

概述---1.查看作业历史记录 SELECT TOP 1000 [instance_id]       ,[job_id]       ,[step_id]       ,[step_name]       ,[sql_message_id]       ,[sql_severity]       ,[message]       ,[run_status]       ,[run_date]    

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

总结

以上是内存溢出为你收集整理的sqlserver 清除维护相关日志全部内容，希望文章能够帮你解决sqlserver 清除维护相关日志所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。