User guide

--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
COMMITTRANSACTION
GOTOEndSave
QuitWithRollback:
IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION
EndSave:
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spTrapAlert_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spTrapAlert_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spSetupAlertsTrap_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spSetupAlertsTrap_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryAlertLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryAlertLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogData_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogData_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryObjectVersion_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryObjectVersion_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetSQL_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetSQL_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetWaittypeDesc_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetWaittypeDesc_20]
SQL Sentry Quick Start 46
©2015 SQL Sentry. All Rights Reserved.