Once we start persisting the job ID of the ingestion job in the tenant record as part of #91240, flavours of ALTER TENANT will be our primary interface to interact with the streaming job. This issue tracks two of the quickest wins around pausing and resuming the streaming job.

• ALTER TENANT <name> PAUSE REPLICATION
• ALTER TENANT <name> RESUME REPLICATION

Jira issue: CRDB-21174

Epic CRDB-18749