For context, the test TestAlreadyRunningJobsAreHandledProperly checks that a corruption of the migration job entry is properly detected.

As currently written, this test only works in the system tenant. It should have a variant that also works for secondary tenants.

Jira issue: CRDB-30020

Epic: CRDB-48526