This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

HSP_HISTORICAL_JOB_STATUS

June 14 2017 at 11:12 AM
No score for this post

Javier 
from IP address 206.108.31.34

I was under the mistaken impression that I could go back as far as required to see who ran what. I just tried to go back to January 2017 and found my earliest recorded job is from mid-March 2017.

Is there a setting that controls how long Planning keeps jobs in the *historical* table?

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply
Pete

124.188.5.16

Re: HSP_HISTORICAL_JOB_STATUS

No score for this post
June 14 2017, 5:25 PM 

In the historical table, I thought it was a number of months. I've queried back 6 months according to the last pull I did?

May be a number of rows?


 
Scoring disabled. You must be logged in to score posts.Respond to this message   

Javier

206.108.31.34

Re: HSP_HISTORICAL_JOB_STATUS

No score for this post
June 14 2017, 7:41 PM 

It's probably a set number of days. I'm at 1070 records in Production and 151 records in Development. The oldest records on both environments are from March 2017.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
 
  << Previous Topic | Next Topic >>Return to Index  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.