User guide

dropprocedure[dbo].[spQueueHeartbeat_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueJob_Start_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueJob_Start_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueJob_End_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueJob_End_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueMonitor_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueMonitor_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spReadLogFile_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spReadLogFile_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryQueueLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryQueueLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogCache_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogCache_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogCacheDTS_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogCacheDTS_20]
GO
BEGINTRANSACTION
DECLARE@JobIDBINARY(16)
DECLARE@ReturnCodeINT
SELECT@ReturnCode=0
--Deletethejobwiththesamename(ifitexists)
SELECT@JobID=job_id
FROMmsdb.dbo.sysjobs
WHERE(name=N'SQLSentry2.0AlertTrap')
IF(@JobIDISNOTNULL)
BEGIN
--Checkifthejobisamulti-serverjob
IF(EXISTS(SELECT*
FROMmsdb.dbo.sysjobservers
WHERE(job_id=@JobID)AND(server_id<>0)))
BEGIN
SQL Sentry Quick Start 45
©2015 SQL Sentry. All Rights Reserved.