none
DPM job history displays only for last 2 months RRS feed

  • Question

  • Hi everyone,

    Can I change the time for which the job history is stored?

    My DPM shows me jobs for only last two months.

    Tuesday, April 7, 2015 7:24 AM

Answers

  • Hi,

    DPM should only keep job history for 30 days. This is not configurable.  DPM runs a housekeeping job nightly to prune expired recovery points and to remove job history older than 30 days.  If you in fact see jobs for longer than that, then something is going wrong with the nightly job and can lead to DPMDB bloat if not fixed.  

    If you have any active alerts more then 30 days, that can prevent older jobs from being deleted.

    You can run the below SQL script to see if you have entries older than 34 days which should have been deleted.

    DECLARE @GCTill DATETIME
    SET @GCTill = DATEADD(DAY,-34,GETDATE() )  -- Today minus 34 days (816hrs)
    print @GCTill
    Select * from tbl_TE_TaskTrail
    where CreatedDateTime <@GCTILL
    
    select * from dbo.tbl_JM_JobTrail
    where EndDateTime <@GCTILL
    
    select * from tbl_AHP_Alerts
    WHERE (Resolution <> 2)
    and OccuredSince <  @GCTILL


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, April 7, 2015 5:20 PM
    Moderator