SOLVED

Should the capacity of a enterprise resource change daily?

%3CLINGO-SUB%20id%3D%22lingo-sub-2868430%22%20slang%3D%22en-US%22%3EShould%20the%20capacity%20of%20a%20enterprise%20resource%20change%20daily%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2868430%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20Project%20Server%202019.%3C%2FP%3E%3CP%3EShould%20the%20capacity%20of%20a%20enterprise%20resource%20change%20daily%20in%20reporting%20database%3F%3C%2FP%3E%3CP%3EIf%20we%20have%20-5%20month%20and%20%2B36%20month%20project%20server%20additional%20settings%2C%20the%20first%20record%20in%26nbsp%3B%5BWSS_PWA%5D.%5Bpjrep%5D.%5BMSP_EpmResourceByDay%5D%20be%20resource%20creation%20date%20minus%205%20month%20and%20the%20last%20record%20be%20current%20date%20plus%2036%20month.%3C%2FP%3E%3CP%3EWith%20best%20regards%2C%20Vasily.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2869589%22%20slang%3D%22en-US%22%3ERe%3A%20Should%20the%20capacity%20of%20a%20enterprise%20resource%20change%20daily%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2869589%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1082084%22%20target%3D%22_blank%22%3E%40Vasily_Zaytsev%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EThis%20will%20update%20daily%2C%20there%20is%20a%20job%20that%20runs%20each%20night%20to%20keep%20this%20data%20updated%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PaulMather_0-1634826383455.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F318972i3B344CEB5BF02967%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PaulMather_0-1634826383455.png%22%20alt%3D%22PaulMather_0-1634826383455.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

We have Project Server 2019.

Should the capacity of a enterprise resource change daily in reporting database?

If we have -5 month and +36 month project server additional settings, the first record in [WSS_PWA].[pjrep].[MSP_EpmResourceByDay] be resource creation date minus 5 month and the last record be current date plus 36 month.

With best regards, Vasily.

1 Reply
best response confirmed by Vasily_Zaytsev (Contributor)
Solution

Hi @Vasily_Zaytsev ,

This will update daily, there is a job that runs each night to keep this data updated:

PaulMather_0-1634826383455.png

Paul