User guide
SELECT@ReturnCode=0
--Deletethejobwiththesamename(ifitexists)
SELECT@JobID=job_id
FROMmsdb.dbo.sysjobs
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)
SQL Sentry Quick Start 44
©2015 SQL Sentry. All Rights Reserved.