Server processes: Difference between revisions

Jump to navigation Jump to search
Line 16: Line 16:
* Real-time: A real-time process is performed immediately. It runs synchronously with the triggering action and it can affect the result of the action.
* Real-time: A real-time process is performed immediately. It runs synchronously with the triggering action and it can affect the result of the action.
* Job: Jobs are not triggered, instead, you can schedule them, e.g., every night at 2 AM; or you can run them on-demand.
* Job: Jobs are not triggered, instead, you can schedule them, e.g., every night at 2 AM; or you can run them on-demand.
== Transaction modes ==
For workflows and jobs, you can also select the transaction mode:
* None - The process is not running as a transaction.
* No Lock - Use Isolation Level "Read Uncommitted".
* Default - Use Isolation Level "Read Committed".
{| class="wikitable sortable"
! Isolation Level<br><span style="font-weight: normal;">([https://en.wikipedia.org/wiki/Isolation_(database_systems) Wikipedia])</span>
! Dirty Read<br><span style="font-weight: normal;"> (transaction is allowed to read data from a row that has been modified by another running transaction and not yet committed)</span>
! Non-Repeatable Read<br><span style="font-weight: normal;"> (during the course of a transaction, a row is retrieved twice and the values within the row differ between reads)</span>
! Phantom<br><span style="font-weight: normal;"> (in the course of a transaction, new rows are added or removed by another transaction to the records being read)</span>
|-
| Read uncommitted || Yes || Yes || Yes
|-
| Read committed  || No  || Yes || Yes
|}


== What can start a process ==  
== What can start a process ==  

Navigation menu