Schedule Routine Tasks in Singlestore

Hi, We currently pay for an ec2 instance to run routine scheduled maintenance on our database, using cron and shell. I am wondering if we can use a pipeline instead? Then all the logic will be available in Singlestore itself, and we can reduce our spend on ec2. If we can pipeline to start a stored procedure, without a message or file we could get it to work. Is this something that is possible, or has been considered?

1 Like

We don’t have a separate agent process that executes jobs on a schedule like this, so you’ll still need an external job scheduler. But, you can execute the call to your stored procedure via the Data API, which may open up more possibilities for your choice and deployment location of your job scheduler.