Scheduled Process: Check if system email is operating

tford

Thanks to BobK for his post at

rbross

Tom,

I know your post was several years ago but I am hoping you can guide me through as I need to create a scheduled event as well. My first question is how and where do you set up a scheduled event?

2nd Like you have shared in the past I have an app that accesses an external SQL DB as well.
What I need to do is setup an event that will update the attribute InventoryValue.TotalInvValue

This value needs to be calculated from one of the external SQL tables. qtyOnHandMovingAverageCost. about 138k records
I want to use the SUM function for this but it appears you cannot use BO.atribute=SUM qtyOnHandMovingAverageCost where(inv_loc.loc_id=1.00) AIM does not like this.

I do not want to have to run a query to find all the inv_loc records everytime i need to update the inv value. So I thought a scheduled process running in the background every few minutes would be best.

I can change the InventoryValues BO from non-persistent to persistent and just update the values.

So what would be the best way to handle something like this?

Thanks

Roger

tford

My first question is how and where do you set up a scheduled event?

In the Configuration Tool, look for scheduling icon toward the bottom.

rbross

Why does the Scheduling Tab go away after you save the new scheduled event?
What if you need to change the scheduling details of the event?
How does the scheduled event get started? Will it start automatically once you go in to test mode and run the app?
Also your example shows how to run an event ever minutes with 1/60
What if you needed the event to run every 5 minutes?
It looks like the TIME_ADD function only lets you add hours what if you want to add minutes can you do something like this: TIME_ADD(LastRunTime,0,2/60)

Roger