Siemens SINUMERIK 840D series Installationshandbuch Seite 222

Lokale Server installieren/deinstallieren
3.9 Wartungsarmer Betrieb
USE [epsTServicesMain]
GO
/****** Object: StoredProcedure [dbo].[DeleteChunkingSessionTempObjectsExpired] Script
Date: 04/30/2015 10:13:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[DeleteChunkingSessionTempObjectsExpired]
@dbVersion int
AS
IN
epsTServicesTmp.dbo.epsTsTmpObj JOIN epsTServicesLocal.dbo.epsTsJob
epsTServicesLocal.dbo.epsTsJob.chunkingSessionId =
epsTServicesTmp.dbo.epsTsTmpObj.sessionId
epsTServicesTmp.dbo.epsTsTmpObj.dateCreated)
@sprocName)
Objects deleted.', 0,1, @rows ) WITH LOG
END
222
-- RAISERROR ('Start delete expired sessions', 0,1 ) WITH LOG
SET NOCOUNT ON
DECLARE @err INT, @rows INT, @sprocName NVARCHAR(256)
SET @sprocName = 'DeleteChunkingSessionTempObjectsExpired'
IF @dbVersion <> 217
BEGIN
RAISERROR (60001, 16, 1, @sprocName)
RETURN 60001
END
BEGIN
-- define 'now' in terms of the UTS date and time
DECLARE @currentDate DateTime, @expirationDate DateTime
SET @currentDate = getutcdate()
SET @expirationDate = @currentDate - 1 -- go back 1 day
SET ROWCOUNT 100
SET @rows = 100 -- start value <> 0
WHILE @rows > 0
BEGIN
DELETE FROM epsTServicesTmp.dbo.epsTsTmpObj WHERE dbIdTmpObj
-- Raise error if there was an error
SELECT @err = @@ERROR, @rows = @@ROWCOUNT
IF @err <> 0
BEGIN
END
END
-- RAISERROR ('End delete expired chunking sessions. %d Temp
RETURN 0
ON
WHERE @expirationDate >
RAISERROR (70007, 16, 1, N'epsTsTmpObj',
RETURN 70007
Installationshandbuch, 08/2017, A5E33520367A-AG
(SELECT dbIdTmpObj FROM
MMP, MMT, AMC, AMP, AMM/E, AMD