User guide
WHERE(name=N'SQLSentry2.0QueueMonitor')
IF(@JobIDISNOTNULL)
BEGIN
--Checkifthejobisamulti-serverjob
IF(EXISTS(SELECT*
FROMmsdb.dbo.sysjobservers
WHERE(job_id=@JobID)AND(server_id<>0)))
BEGIN
--Thereis,soabortthescript
RAISERROR(N'Unabletoimportjob''SQLSentryQueueMonitor''sincethere
isalreadyamulti-serverjobwiththisname.',16,1)
GOTOQuitWithRollback
END
ELSE
--Deletethe[local]job
EXECUTEmsdb.dbo.sp_delete_job@job_name=N'SQLSentry2.0QueueMonitor'
SELECT@JobID=NULL
END
COMMITTRANSACTION
GOTOEndSave
QuitWithRollback:
IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION
EndSave:
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetJobInfo_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetJobInfo_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetDTSLog_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetDTSLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueHeartbeat_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueHeartbeat_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueJob_Start_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueJob_Start_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueJob_End_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueJob_End_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spQueueMonitor_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spQueueMonitor_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spReadLogFile_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
SQL Sentry Quick Start 41
©2015 SQL Sentry. All Rights Reserved.