#378 MEDIUM: SchedulerService breaks atomic transaction boundary

scheduler_service.py uses autocommit=True but needs atomic scan+submit+update operation. Uses different connections for submit vs update. Could cause duplicate workflow submissions on crash. Fix: Use single connection without autocommit.