2015年9月30日 星期三

SCOM - 如何清除舊資料 ?

USE [OperationsManager]
DECLARE @rowcount int
DECLARE @Err int
DECLARE @GroomingThresholdUTC datetime
SET @GroomingThresholdUTC = getutcdate()
EXEC @Err = dbo.p_DiscoveryDataPurgingByTypedManagedEntity @GroomingThresholdUTC,250, 0
EXEC @Err = dbo.p_DiscoveryDataPurgingByRelationship @GroomingThresholdUTC,250, 0

EXEC @Err = dbo.p_DiscoveryDataPurgingByBaseManagedEntity @GroomingThresholdUTC,250, 0

1 則留言:

  1. Msg 8144, Level 16, State 2, Procedure p_DiscoveryDataPurgingByTypedManagedEntity, Line 0
    Procedure or function p_DiscoveryDataPurgingByTypedManagedEntity has too many arguments specified.

    回覆刪除