Thanks jcoates and richgalloway for all the suggestions.
In the end, I just needed to review my data carefully and think it through.
I have another field - Run End, which tells me when the long running job finishes. So I now use that as the Rising Column. This means that I now dont pick up the default state "Run Successfully" = false. I now only pick up the true run success state as it updates when it updates the Run End field.
I have also managed to create my first alert, also using the dedup command.
I have a different question now, which I will ask in a new thread.
... View more