Scan for startup procs

Name:	Scan for startup procs
Platform:	Sqlserver
Category:	Security
Premium package:	Security and compliance package
Description:	Check if MS SQL Server automatically scan and run all stored procedures that are set to execute upon service startup.
Long description:	Check if MS SQL Server automatically scan and run all stored procedures that are set to execute upon service startup.
Version:	1.2
Default schedule:	26 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 “scan for startup procs” parameter is enabled.
disable scan for startup procs	NO	If set to “YES” the alert will disable “scan for startup procs” (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