Business rule vs scheduled job

[ryadavalli]

We have a requirement to update a flag x on the user record depending on the value on another field y.

We have 3 options:

1) Write a after BR which executes when the record is updated or inserted and update the flag x depending on y flag - Will get called with every update

2) Scheduled job (nightly) which will run right after the the user records are transformed and get all the records where field y is changed and set the flag x.

3) Write an on After transform script - This might delay the transform

Performance wise which one is better, thoughts ?

Thanks,

[Chuck Tomasi]

The question is WHEN do you want to it to run? If you put it in a BR, it will only affect the records that are created/updated as they are done. Older records may never get updated.

The scheduled job can do a complete sweep of everything - which you may only need periodically, but some records could be out of date.

I recommend a two pronged approach to get older records up to date using a scheduled job (or fix script) that runs once and use a BR to keep values up to date going forward.

[ryadavalli]

We want to go about only the record inserted/updated going forward. For that, is a BR would be effective or a scheduled job on a daily basis which will look for all the updated one for that day and set the flag to true if the field y is changed to certain value ?

[ryadavalli]

With BR, every user record will be checked for the condition of the BR, but if it is a scheduled job, it will run one time and get the result set and will work on it, thats the question I have here.

Thanks,

[pavank]

Rayali,

You can create a business rule which triggers only when Field y is changed. That would be a better solution in this scenario.