User guide

dropprocedure[dbo].[spReadLogFile_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryQueueLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryQueueLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogCache_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogCache_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogCacheDTS_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogCacheDTS_20]
GO
BEGINTRANSACTION
DECLARE@JobIDBINARY(16)
DECLARE@ReturnCodeINT
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(@JobIDISNOTNULL)
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
--Thereis,soabortthescript
RAISERROR(N'Unabletoimportjob''SQLSentryAlertTrap''sincethereis
alreadyamulti-serverjobwiththisname.',16,1)
GOTOQuitWithRollback
END
ELSE
--Deletethe[local]job
EXECUTEmsdb.dbo.sp_delete_job@job_name=N'SQLSentry2.0AlertTrap'
SELECT@JobID=NULL
END
COMMITTRANSACTION
GOTOEndSave
QuitWithRollback:
IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION
EndSave:
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spTrapAlert_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
SQL Sentry Quick Start 42
©2015 SQL Sentry. All Rights Reserved.