Disable all triggers in orphaned job artifacts spec

What does this MR do and why?

The related spec fails on CI likely because we only disable triggers for the partitioned table, not for all partitions. While we're not completely certain, this approach should resolve the issue.

This commit sets session_replication_role to replica to disable all triggers.

References

Related to #546155 (closed) #543283 (closed) #543284 (closed)