USE ASPState GO DECLARE @jobID BINARY (16) SELECT @jobID = job_id FROM msdb.dbo.sysjobs WHERE name = N'ASPState_Job_ExpireViewState' IF (@JobID IS NOT NULL ) BEGIN IF EXISTS ( SELECT * FROM msdb.dbo.sysjobservers WHERE job_id = @JobID AND server_id...