Sentry Sentry 2.0 Betriebsanweisung PDF herunterladen (Seite 45)

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]

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

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

Keine Kommentare

Sentry Sentry 2.0 Betriebsanweisung Seite 45