locked
Batch Process in MicrosoftDynamcis AX---need help RRS feed

  • Question

  • Hi All,

    I have created a batch class in Dynamics AX, which takes data from SQL Server database and puts data into AX Table. Now I attach the batch class with a batch group, say Grp1 and set the time as t, it is going to execute the class at time t. But again if I attach the same class to another batch group say Grp2, and set the same time as again t, then in the batch list, I can see two batches in the waiting state. Now at time t, the two batches are going to execute.

    Now my question is how will I maintain concurrency in this scenario, both the batches are fatching the same data from db and inserting it to AX. I have one status field in the db table records and I am updating that field once the data is imported/inserted into ax table, but as both the batches are running at the same time, both are picking the same records from db and inserting it to ax before updating the status field by any one of the batches.

    Please help me in this regard.

    you can also mail me to dhruba.borchetia@gmail.com.

    Regards
    Dhruba
    Friday, September 11, 2009 9:08 AM

Answers

  • Sorry, wrong forum, you are here in the dynamics CRM forum.

    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    • Marked as answer by Jim Glass Jr Friday, September 11, 2009 3:09 PM
    Friday, September 11, 2009 9:39 AM