NuRoN Consulting, INC.

Blog > SQL Tools > Databases > master > Procedures > sp_NotifyServerStart

Dependencies for System Startup Stored Procedure: master.dbo.sp_NotifyServerStart

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
master.dbo.sp_NotifyServerStart	Stored procedure	master.dbo.sp_SysInfo	Stored procedure	1	[master].[dbo].[sp_SysInfo]
master.dbo.sp_NotifyServerStart	Stored procedure	msdb.dbo.sp_send_dbmail	Stored procedure	1	[msdb].[dbo].[sp_send_dbmail]
master.dbo.sp_SysInfo	Stored procedure	Util.dbo.GetDateTimeDifference	SQL scalar function	2	[master].[dbo].[sp_SysInfo], [Util].[dbo].[GetDateTimeDifference]
master.dbo.sp_SysInfo	Stored procedure	Util.dbo.StringConcat	Aggregate function (CLR)	2	[master].[dbo].[sp_SysInfo], [Util].[dbo].[StringConcat]
msdb.dbo.sp_send_dbmail	Stored procedure	msdb.dbo.get_principal_id	SQL scalar function	2	[msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[get_principal_id]
msdb.dbo.sp_send_dbmail	Stored procedure	msdb.dbo.sp_validate_user	Stored procedure	2	[msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[sp_validate_user]
msdb.dbo.sp_send_dbmail	Stored procedure	msdb.dbo.sysmail_principalprofile	Table	2	[msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[sysmail_principalprofile]
msdb.dbo.sp_send_dbmail	Stored procedure	msdb.dbo.sysmail_verify_profile_sp	Stored procedure	2	[msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[sysmail_verify_profile_sp]
msdb.dbo.sysmail_verify_profile_sp	Stored procedure	msdb.dbo.sysmail_profile	Table	3	[msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[sysmail_verify_profile_sp], [msdb].[dbo].[sysmail_profile]
Util.dbo.StringConcat	Aggregate function (CLR)	Util.UtilClr	ASSEMBLY	3	[master].[dbo].[sp_SysInfo], [Util].[dbo].[StringConcat], [Util].[UtilClr]

System Startup Stored Procedure: master.dbo.sp_NotifyServerStart

USE master
GO
IF OBJECT_ID('sp_NotifyServerStart') IS NULL EXEC ('CREATE PROCEDURE sp_NotifyServerStart AS SELECT 1 AS ID')
GO
ALTER PROCEDURE dbo.sp_NotifyServerStart
AS
DECLARE @recipients NVARCHAR(1000) = 'ascheepers@corelogic.com;gvarol@corelogic.com;marsilva@corelogic.com',
    @subject VARCHAR(1000) = 'SQL SERVER SERVICE STARTED'
SET NOCOUNT ON
IF @recipients <> ''
    BEGIN
        DECLARE @InFo NVARCHAR(MAX)
        EXEC dbo.sp_SysInfo
            @ReturnInfo = 1,
            @InFo = @InFo OUTPUT

        EXEC msdb.dbo.sp_send_dbmail
            @recipients = @recipients,
            @subject = @subject,
            @body = @InFo
    END
GO
EXEC sys.sp_ms_marksystemobject sp_NotifyServerStart
GO
RETURN -- !!! BELOW BATCH WILL ENABLE STARTUP PROCEDURE LOOKOUT ON THE SERVER. IT IS A SERVER LEVEL SETTING AND WILL BE SKIPPED BY THIS RETURN STATEMENT !!!
-- SETUP THE SERVER TO SHOW ADVANCED OPTIONS
EXEC sp_configure 'show advanced option', '1';

RECONFIGURE
-- SETUP SCANNING FOR STARTUP PROCS
EXEC sp_configure 'scan for startup procs', '1';

RECONFIGURE
GO
EXEC sp_procoption N'sp_NotifyServerStart', 'startup', 'ON'
GO

Description for System Startup Stored Procedure: master.dbo.sp_NotifyServerStart

Todo