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

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QueueMonitor')

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QueueMonitor''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QueueMonitor'

SELECT@JobID=NULL

END

COMMITTRANSACTION

GOTOEndSave

QuitWithRollback:

IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION

EndSave:

GO

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

[spGetJobInfo_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spGetJobInfo_20]

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

[spGetDTSLog_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spGetDTSLog_20]

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

[spQueueHeartbeat_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spQueueHeartbeat_20]

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

[spQueueJob_Start_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spQueueJob_Start_20]

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

[spQueueJob_End_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spQueueJob_End_20]

SQL Sentry Quick Start 48

©2015 SQL Sentry. All Rights Reserved.

1 2 ... 43 44 45 46 47 48 49 50 51 52 53 54 55 56

Comentarios a estos manuales

Sin comentarios