नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
SQL Server
Deletes events from the Database Mail log. Deletes all events in the log or those events meeting a date or type criteria.
Transact-SQL syntax conventions
Syntax
sysmail_delete_log_sp [ [ @logged_before = ] 'logged_before' ]
[ , [ @event_type = ] 'event_type' ]
[ ; ]
Arguments
[ @logged_before = ] 'logged_before'
Deletes entries up to the date and time specified by the @logged_before argument. @logged_before is datetime with NULL as default. NULL indicates all dates.
[ @event_type = ] 'event_type'
Deletes log entries of the type specified as the @event_type. @event_type is varchar(15) with no default. Valid entries are:
successwarningerrorinformational
NULL indicates all event types.
Return code values
0 (success) or 1 (failure).
Remarks
Use the sysmail_delete_log_sp stored procedure to permanently delete entries from the Database Mail log. An optional argument allows you to delete only the older records by providing a date and time. Events older than that argument will be deleted. An optional argument allows you to delete only events of a certain type, specified as the @event_type argument.
Deleting entries in the Database Mail log doesn't delete the e-mails entries from the Database Mail tables. Use sysmail_delete_mailitems_sp to delete e-mail from the Database Mail tables.
Permissions
You can grant EXECUTE permissions on this procedure, but these permissions might be overridden during a SQL Server upgrade.
Examples
A. Delete all events
The following example deletes all events in the Database Mail log.
EXECUTE msdb.dbo.sysmail_delete_log_sp;
GO
B. Delete the oldest events
The following example deletes events in the Database Mail log that are older than October 9, 2022.
EXECUTE msdb.dbo.sysmail_delete_log_sp @logged_before = 'October 9, 2022';
GO
C. Delete all events of a certain type
The following example deletes success messages in the Database Mail log.
EXECUTE msdb.dbo.sysmail_delete_log_sp @event_type = 'success';
GO