@Lalit - Question, instead of creating an Activity "UpdateSalesCess" and then using the DT to do the logic, why can't we use "pxCallDataTransform" activity directly within the Job scheduler and pass the "UpdateSalesCess" DT as parameter which does the same job ? Do you see any issues when we do it that way. This way we can even avoid the activity altogether ? Just a thought.
In some business scenario where even if contention happens, it won’t business much or if you have a proper flag which tell that it has been already processed so that other node can skip.
I have a requirement , there is job scheduler which has to run 7 am, In India and Australia, Same job scheduler running at 7 am India and Australia time , how to achieve this
You can run a JS and determine the time in gmt and then from JS queue to a delayed QP and each item will have their own delayed time for a particular country.
Directly with DT we can not fetch a data from table, either we need call an activity in DT or We need to use Data page(source with RD) reference in the DT to fetch a data from a table.
@Lalit - Question, instead of creating an Activity "UpdateSalesCess" and then using the DT to do the logic, why can't we use "pxCallDataTransform" activity directly within the Job scheduler and pass the "UpdateSalesCess" DT as parameter which does the same job ? Do you see any issues when we do it that way. This way we can even avoid the activity altogether ? Just a thought.
We can absolutely do what you said.. no issues at all..
@lalit, when can we run the jobscheduler on multiple nodes?
In some business scenario where even if contention happens, it won’t business much or if you have a proper flag which tell that it has been already processed so that other node can skip.
I have a requirement , there is job scheduler which has to run 7 am, In India and Australia,
Same job scheduler running at 7 am India and Australia time , how to achieve this
You can run a JS and determine the time in gmt and then from JS queue to a delayed QP and each item will have their own delayed time for a particular country.
So we need to have one job scheduler as well as one qp which will actually do our job based on a different time zone..am I corrected?
Yes… one JS and one QP
How to fetch data from table with datatransform rule
Try to use single or list data pages accordingly with parameters!
Directly with DT we can not fetch a data from table, either we need call an activity in DT or We need to use Data page(source with RD) reference in the DT to fetch a data from a table.
Yes, you to call activity or datapage or any other type of rule.