Replace scheduler service with DBOS for improved reliability

[nehmetohmedb]

Replace scheduler service with DBOS for improved reliability

Problem

Current scheduler service uses custom scheduling logic that could benefit from database-backed durability and automatic recovery.

Proposed Solution

Replace scheduler_service.py with DBOS scheduled workflows:

@DBOS.scheduled('0 */6 * * *')  # Every 6 hours
@DBOS.workflow()
async def cleanup_old_executions():
    await perform_cleanup_operations()

Benefits

• Built-in persistence and reliability
• Automatic recovery if service restarts
• Simplified codebase
• Database-backed scheduling state

Next Steps

1. Add DBOS dependency
2. Pilot implementation for scheduled cleanup tasks
3. Evaluate for broader workflow execution use cases

Resources: DBOS Documentation