Trigger Sync

Trigger a manual resync for a connector source.

Uses a single session (svc.session) for both the parent job insert and the atomic source-status flip, so the writes commit together. The UPDATE is guarded by status IN ('active','error') so concurrent trigger_sync calls can't both flip the same source into SYNCING.