Hi,
I am trying to achieve the following:
I want to make an update to some orders that meets certain conditions. I also want this process to be scheduled to run at some time in a regular basis.
I was trying to use Data Query within Business Process Automation/Process Management option becuase this allows for scheduling and recurrence. So I defined a saved query with the update sql query. The problem is that when I try to run the data query it does not allow the saved query to run as it is not a select kind of query.
I know that this could be easily be done in the actual DB. But the idea behind this is to give an OTM user the ability to control when do the update can take place.
Any ideas of how can this be achieved? Are there any other way to accomplish the same?
Many thanks in advance
Sincerely,
Ricardo
I am trying to achieve the following:
I want to make an update to some orders that meets certain conditions. I also want this process to be scheduled to run at some time in a regular basis.
I was trying to use Data Query within Business Process Automation/Process Management option becuase this allows for scheduling and recurrence. So I defined a saved query with the update sql query. The problem is that when I try to run the data query it does not allow the saved query to run as it is not a select kind of query.
I know that this could be easily be done in the actual DB. But the idea behind this is to give an OTM user the ability to control when do the update can take place.
Any ideas of how can this be achieved? Are there any other way to accomplish the same?
Many thanks in advance
Sincerely,
Ricardo
Comment