Database Mail XPs

Name:	Database Mail XPs
Platform:	Sqlserver
Category:	Security
Premium package:	Security and compliance package
Description:	Checks the ability to generate and transmit email messages from SQL Server.
Long description:	Checks the ability to generate and transmit email messages from SQL Server.
Version:	1.2
Default schedule:	8 1 1 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ \| engine_edition = ‘Azure SQL Managed Instance’)

Parameters
Name	Default value	Description
return status	1	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when the “Database Mail XPs” parameter is enabled.
disable Database Mail XPs	NO	If set to “YES” the alert will disable “Database Mail XPs” (if it is enabled) by running sp_configure stored procedure.
history threshold	365	The maximum number of days to keep statistics for in the historic tables.

Feedback