AX 2012 Report Performance

• The issue is caused by srs recycling which is by default set to 720minutes.
  

  You need to edit reporting server config (msdn.microsoft.com/.../ms157273.aspx)

  to change that.
  c:\program files\microsoft sql server\msrs10.mssqlserver\reporting services\reportserver\RSReportServer.config
  set RecycleTime parameter to lets say 1440. Time units are minutes

updating Employment history in ax 2012

static void Job2(Args _args)
{
HcmEmployment   HcmEmployment;
HcmWorker       HcmWorker;  
 Companyinfo companyinfo;
   
    ;
    while select * from HcmWorker
    {
        while select * from Companyinfo
        {
            select * from  HcmEmployment where HcmEmployment.Worker == HcmWorker.RecId
                                           &&  HcmEmployment.LegalEntity ==  Companyinfo.RecId;
            if(!HcmEmployment)
            {
                ttsBegin;
                HcmEmployment.Worker        = HcmWorker.RecId;
                HcmEmployment.LegalEntity   =  Companyinfo.RecId;  
                HcmEmployment.ValidFrom     = DateTimeUtil::newDateTime(DateTimeUtil::date(DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::utcNow(), DateTimeUtil::getUserPreferredTimeZone())), 0);
                HcmEmployment.ValidTo       = DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::maxValue(), DateTimeUtil::getUserPreferredTimeZone());
                HcmEmployment.insert();
                ttsCommit;
           
            }      
        }
    }
}