Someone else can probably provide definitive information, but this is what I have observed for our tasks. For a successful task, the execution results are:
Changing task state to Triggered.
Trying to start task. Sending task to slave scheduler
Changing task state from Triggered to Started
Reference to scriptlog added
Changing task state from Started to FinishedSuccess
The possible execution statuses are below:
At a first approximation based on knowledge and a few hunches:
I'll chime in here from the Scheduler perspective:
On top of this there is various levels of timeouts, internal details of the Engine, and various entities the Master scheduler creates, updates, and removes from the Repository (ExecutionSession, ExecutionResult, ...).
Besides this basic flow there are also other states which will be entered
You mentioned the below point from the list.
What is "Saves the Diff" in the sentence. Could you please explain. what will save in Transactions folder.