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

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dbo.sysobjectswhereid=object_id(N'[dbo].

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

dropprocedure[dbo].[spGetJobInfo_20]

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

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

dropprocedure[dbo].[spGetDTSLog_20]

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

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

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)

SQL Sentry Quick Start 41

©2015 SQL Sentry. All Rights Reserved.

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

Comentarios a estos manuales

Sin comentarios