Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
	-- Reset any Application that DataTTL has expired since the last scan attempt
	UPDATE dbo.[ApplicationScanHistory]
		SET [AttemptCount] = @MaxFailures-1
	WHERE [ApplicationScanHistoryID]IN
		(
			SELECT [ApplicationScanHistoryID]
			FROM [ApplicationScanHistory] ash WITH( NOLOCK )
			JOIN [Application] a WITH( NOLOCK ) ON a.[ApplicationID] =ash.[ApplicationID]
			WHERE ([ServiceTypeEnumID] = @ServiceTypeEnumID
				AND a.[DataTTL] is not null 
				AND DATEADD(DAY, a.[DataTTL], ash.[LastAttemptDate]) <= @CurrentDate)
				AND ash.[AttemptCount] >= @MaxFailures);	






 

Filter by label (Content by label)
showLabelsfalse
max5
spacesCSKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("vcenter","fix") and type = "page" and space = "CSKB"
labels vCenter Fix

Page Properties
hiddentrue


Related issues
Jira Legacy
serverJIRA (iquate.atlassian.net)
serverId2df96907-46e3-3301-b062-728a2d6c89be
keyCS-3