Hi All, Is there a way that users can still access and work in the database while you run the Adjust cost - Item entries Batch Job? SQL locks the tables and was thinking of creating temp tables in sql but dont know if this would work… Any Advice?
Sorry - You should run those jobs at night, when no-one are posting.
The job takes time if you dont run it on daily basis. If you give time to run for 1 time and after that you run it daily, it should not take more than 15 minutes to complete (If data is correct)