Sentry Sentry 2.0 Uživatelská příručka stáhnout pdf (Strana 42)

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]

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

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

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[spTrapAlert_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

SQL Sentry Quick Start 42

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 55 56

Žádné komentáře

Sentry Sentry 2.0 Uživatelská příručka Strana 42