Sentry Sentry 2.0 Guía de usuario descargar pdf (Pagina 46)

--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.

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 55 56

Comentarios a estos manuales

Sin comentarios