Make run_result.json parsable even in case of task execution error

[Ben8t]

Feature description

Users want to send notifications of corresponding error dbt models but can't as the run_results. json can't be parsed from outputs (task execution in error state doesn't expose outputs properties).

One workaround is to make the task fails silently (dbt --log-format-file json build --select <MODEL NAME> --target prod 2>/dev/null || true) and direct the stderr to the null device and add an OR condition with true, making the flow always return a successful run, then parse my run_results.json and potentially add a block of io.kestra.core.tasks.executions.Failif detect an error