Sign inTry Free

Schedule Jobs

On this page

A scheduled execution of a notebook is referred to as a “job.” The SingleStore job service provides a flexible and convenient way to schedule jobs using cron expressions that can be tailored to meet your requirements. Cron-based scheduling uses the standard cron syntax, providing precise control over when workloads are run. It supports the format - minute hour day month weekday, and allows for complex scheduling patterns (e.g., running jobs at 8:00 AM every Monday). Create, edit, and delete cron schedules, and validate cron expressions in real time.

After scheduling, the job service creates a snapshot. This snapshot represents a read-only notebook captured at the time the job was scheduled. It can be used for subsequent executions at the scheduled time until the user makes modifications. To ensure that the execution reflects the new changes, be sure to update the snapshot explicitly after modifying the notebook.

Create and manage scheduled jobs using the Cloud Portal or via the Management API.

Schedule Jobs using the Cloud Portal

Create a Scheduled Job

Jobs can be scheduled for shared notebooks only. Create a scheduled job:

  • Using Jobs in the left navigation

    Select Schedule (on the top right).

    In the left navigation, select Jobs, and then select Schedule to schedule a job.

  • Using Shared Notebooks

    1. Navigate to Editor > Shared .

    2. Select a shared notebook.

    3. Select Schedule (on the top right).

    Schedule a notebook by selecting the Schedule button on the right upper side in the shared notebook.

New Scheduled Job

After selecting Schedule, a dialog box will appear.

Enter the Job Settings.

Enter the job settings for scheduling a job

Job Settings

Name

Enter a name for the job.

Description

Enter the job description.

Notebook

Select a shared notebook to run the job. The shared notebook is pre-selected when Job is scheduled through notebooks.

Deployment

Select the SingleStore deployment (workspace) the notebook connects to.

Selecting a workspace allows connecting the SingleStore databases referenced in the notebook natively. A scheduled job can also be run without a deployment attached to it.

Runtime

Select a runtime from the following:

  • Small

  • Medium

  • GPU-T4

Note

This field is in preview.

Region

Select a region.

Select Next. Enter the Schedule Options.

Scheduled Options

Start Executions After

Specify the date and time for the first run of the scheduled job. Select one of the following available options:

  1. Now: The job runs as soon as it is created.

  2. Datetime: Specify a Starting Date and Starting Time.

Schedule Mode

Specify the frequency to run a scheduled job. Select one of the following available options:

  1. One Time: The job runs a single time.

  2. Recurring: Specify when the job needs to be run. Select from the following:

    • Hourly

    • Weekly

    • Monthly

    • Weekdays at 9 PM

    • Every 6 Hours

    • Enter a custom valid CRON expression.

Parameters

Specify the job parameters for the scheduled job. 

  1. Type: Select the type of parameters from the following:

    • String

    • Integer

    • Float

    • Boolean

  2. Name: Enter the name of the parameter.

  3. Value: Enter the value of the parameter.

Note

The system injects parameters as Python variables into the notebook while the scheduled job runs, and access them using the variables where required.

Additional Settings

  1. Save all execution results: Enable this setting to save the execution results. An execution result is a saved version of the notebook along with the cells containing outputs after the completion of a job run. This action enables to validate the execution result and the version of the notebook used for the run. By default, all snapshots for error and failed runs are saved.

  2. Auto resume the deployment on job execution: Enable this setting to resume the deployment when the job runs. This action resumes any suspended workspace deployments. The previous auto-suspend settings of the workspace remain unchanged.

Select Next.

View the summary of the job before creating a job.

Select Create Job to schedule the job.

Manage an Existing Job

To view an existing scheduled jobs and job runs, select Jobs in the left navigation pane. Existing jobs can be managed by performing the following actions:

  • View

  • Edit

  • Pause

  • Resume

  • Delete

View an Existing Job

To view a job, select the job name under the Name column.

View the scheduled job under the Name column in the Jobs page.

View the following job execution details for each job:

View the job execution details in the right navigation of the selected job.

View the details of a job on the Job Details pane in the right navigation. This page also supports refresh, edit, pause, resume, and delete actions for a job.

Edit an Existing Job

To edit an existing job, navigate to the selected job page, select the ellipsis, and select Edit Job.

Edit the job by selecting Edit Job in the ellipsis of the selected job.

Pause an Existing Job

To pause an existing job, navigate to the Jobs page, select the ellipses in the Actions column of the job, and select Pause. Alternatively, navigate to the selected job page, and select Pause Job.

Resume an Existing Job

To resume an existing job, navigate to the Jobs page, select the ellipses in the Actions column of the job, and select Resume.

Delete an Existing Job

To delete an existing job, navigate to the Jobs page, select the ellipses in the Actions column of the job, and select Delete.

Warning

Deleting a job removes all associated job runs, including snapshots.

Schedule Jobs using the Management API

Use the Jobs path (/v1/jobs endpoint) to create and manage jobs using the Management API. Refer to Management API and Management API Reference for more information.

For example, the following API call returns information about the job with the specified jobID:

curl -X 'GET' \  'https://api.singlestore.com/v1/jobs/7b68b78d-0000-1000-9000-0864fd331524' \  -H 'accept: application/json'

Status of Job Executions

Status

Description

Scheduled

The next scheduled run for the job. The latest version of the notebook runs at the Start Time associated with the job.

Completed

The notebook in this job run ran to completion.

Failed

The execution failed due to user error. View execution result to debug the failure.

Error

An error unrelated to the notebook code prevented this job from completing. Refer to Troubleshoot Job Runs.

Troubleshoot Job Runs

SingleStore automatically saves an execution result notebook of an execution that fails. Navigate to Jobs in the left navigation, find the job, and download the snapshot associated with the failed job run to diagnose the error.

Error

Solution

Workspace Deleted

Edit the Job and select a deployment.

Workspace Suspended

Resume the workspace, or create a new job schedule with a different deployment.

Database Detached

Reattach the database with the right permissions or create a new schedule job with a different database.

Internal Errors / Misc

Reach out to SingleStore Support or use the chat feature in the Cloud Portal.

Notebook Timed Out

View the snapshot to identify the cells where the notebook is timed out.

Refer to Configurability and Key Considerations for the Execution Time limits set on a job run.

Notebook Deleted/Not present

Create a new scheduled job with a different notebook.

Configurability and Key Considerations

The snapshot version of a notebook runs at the scheduled start time. To make changes to a notebook without affecting a scheduled job run, create a duplicate of the notebook.

An execution time limit is set for each job run which is determined by the organization:

No Active Deployment

Active Shared Workspace in Free Shared Edition

Active Standard Workspace

Active Workspace in Enterprise Edition

Maximum allowed execution duration

5 minutes

15 minutes

15 minutes

30 minutes < x < 120 minutes.

Where x = Execution interval/5

Minimum execution interval

60 minutes

60 minutes

60 minutes

60 minutes

Maximum execution interval

30 days

30 days

30 days

30 days

Total active recurring jobs

1

5

5

30

Last modified: November 27, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK

Try Out This Notebook to See What’s Possible in SingleStore

Get access to other groundbreaking datasets and engage with our community for expert advice.

Sign UpLog In