Solved

Is it possible to schedule 'Refresh All Inventory Parts' job based on a Site?

  • 5 October 2021
  • 4 replies
  • 137 views
Nimesh Kasun
Rank
Userlevel 6
Badge +10

Hi community,

Product: App9 - UPD16

 

A customer has 24/7 service globally and they are scheduled to run Refresh All Inventory Parts twice a day. It’s running for 2+ hours sometimes (not identified the situation). Usually it runs within 10mins for them. 

Since they have many mobile users connecting to the system during the same time period, and since the job locks all these user sessions, the system run out of the connection pool and goes down for all users.

 

Question:

Can this job “Refresh All Inventory Parts” scheduled to be run based on site?

 

So that they can schedule few jobs where each job runs in off-peak time for each site. Appreciate any inputs.

icon

Best answer by Bandula 7 October 2021, 14:25

View original
Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
This topic has been closed for comments

4 replies

Bandula
Rank
Userlevel 6
Badge +12

Hi Nimesh,

In the current design, first thing done inside Refresh_All_Inv_Parts() method is delete all records in MOBILE_USER_INVENT_PART_TAB

Then run different cursor to repopulate the table. eg. connected warehouses, materials, returns and etc.

So it is not possible to run based in site. 

But you can try out a workaround solution like writing a custom method or event to insert records (new part/user combinations) to MOBILE_USER_INVENT_PART_TAB when you want to send a new part. Then you can keep Refresh_All_Inv_Parts job to off peak time.

 

Bandula
Rank
Userlevel 6
Badge +12

Hi @Nimesh Kasun  Yes, if the workaround implemented they don’t need to run the task daily. 

But please note current refresh task collect part/user data from different sources. eg.connected warehouses, materials, returns and few more. So if they not run the task daily, their custom method need to take care of all. 

Please have look on   Mobile_User_Invent_Part_API.Refresh_All_Inv_Parts()  method in plsq. Then you can get an idea how we populate the table. 

Nimesh Kasun
Rank
Userlevel 6
Badge +10

Hi @Bandula,

Thank you for the response.

If the customer implements the workaround, then is it ok to run the Refresh_All_Inv_Parts job during weekends? Will that be an issue?

Because, customer doesn’t have common off-peak hours as users are accessing the system globally. 

 

/Nimesh

 

Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
Nimesh Kasun
Rank
Userlevel 6
Badge +10

Hi @Bandula,

Thank you for your support. Customer has implemented the suggestion from their end.

/Nimesh 

Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
Terms & ConditionsCookie settings