oxibase 0.5.13

Autonomous relational database management system with MVCC, time-travel queries, and full ACID compliance
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

---
layout: default
title: CREATE SCHEDULE
parent: Utility Commands
grand_parent: SQL Commands
---

# CREATE SCHEDULE

<div id="rrdiagram"></div>
<script class="railroad-diagram-script">
  (function() {
    var diagram = Diagram([
      Sequence([
        Keyword("CREATE SCHEDULE"),
        Optional(Sequence([Keyword("IF NOT EXISTS")])),
        NonTerminal("schedule_name"),
        Keyword("CRON"),
        NonTerminal("cron_expression"),
        Keyword("CALL"),
        NonTerminal("procedure_name"),
        Keyword("()")
      ])
    ]);
    document.getElementById("rrdiagram").innerHTML = diagram.toString();
  })();
</script>

Creates a new background job schedule that executes a stored procedure at specified intervals using standard Cron syntax.

#### Basic Syntax

```sql
CREATE SCHEDULE [IF NOT EXISTS] schedule_name 
    CRON 'cron_expression' 
    CALL procedure_name();
```

#### Examples

```sql
-- Run the cleanup procedure every night at midnight
CREATE SCHEDULE nightly_cleanup 
    CRON '0 0 0 * * *' 
    CALL cleanup_old_data();

-- Run every 5 minutes
CREATE SCHEDULE refresh_stats 
    CRON '0 */5 * * * *' 
    CALL update_statistics();
```