create_scheduled_job
Schedule automated execution of SingleStore notebooks for tasks like ETL workflows, data aggregation, reporting, and maintenance. Supports one-time or recurring runs with optional snapshot backups.
Instructions
Create an automated job to execute a SingleStore notebook on a schedule.
Parameters:
- notebook_path: Complete path to the notebook
- mode: 'Once' for single execution or 'Recurring' for repeated runs
- create_snapshot: Enable notebook backup before execution (default: True)
Returns Job info with:
- jobID: UUID of created job
- status: Current state (SUCCESS, RUNNING, etc.)
- createdAt: Creation timestamp
- startedAt: Execution start time
- schedule: Configured schedule details
- error: Any execution errors
Common Use Cases:
1. Automated Data Processing:
- ETL workflows
- Data aggregation
- Database maintenance
2. Scheduled Reporting:
- Performance metrics
- Business analytics
- Usage statistics
3. Maintenance Tasks:
- Health checks
- Backup operations
- Clean-up routines
Related Operations:
- get_job_details: Monitor job
- list_job_executions: View job execution history
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| create_snapshot | Yes | ||
| ctx | No | ||
| mode | Yes | ||
| notebook_path | Yes |