Public Profile
  • Speed up GP RECONCILE and CHECK LINKS

    Issue: Check links and reconcile takes far too long to run

    If the business logic were pulled out of dexterity and these were re-implemented in SQL using set based operations, this would transform a very painful aspect of running GP on large databases. 

    Once in SQL it could be scheduled from SQL jobs and results emailed via SQL for those of us with those skills. This would address the issue of unattended scheduling of these tasks which is another suggestion. 

    Even if just the key three pilars of SOP/POP/IV modules were addressed, I'm certain an operation that currenly takes more than a weekend duration to run (currently), would be reduced into minutes. 

     

     

     

  • Allow unattended scheduling of CHECKLINKS and RECONCILES

    The ability to get GP to run a check links and reconcile automatically via a schedule would transform the admin of larger sites. 

    I would love to reconcile our SOP and POP each night and IV over weekends, automatically and have the resulting reports written to a directory for me to review. Even if it meant passing params to GP application via windows scheduler or having another application to run on the server. Alternatively hooks into these processes for GP Addin would help.

    This is a hidden pain of GP admin currently. 

    This also relates but not depends on another suggestion, of moving the reconcile and check links into SQL for easier management.