<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="event-scheduler">
      </a>
      27.4 Using the Event Scheduler
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="events-overview.html">
       27.4.1 Event Scheduler Overview
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="events-configuration.html">
       27.4.2 Event Scheduler Configuration
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="events-syntax.html">
       27.4.3 Event Syntax
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="events-metadata.html">
       27.4.4 Event Metadata
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="events-status-info.html">
       27.4.5 Event Scheduler Status
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="events-privileges.html">
       27.4.6 The Event Scheduler and MySQL Privileges
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045082265648">
  </a>
  <a class="indexterm" name="idm46045082264608">
  </a>
  <p>
   The
   <span class="firstterm">
    MySQL Event Scheduler
   </span>
   manages the scheduling and execution of events, that is, tasks that
    run according to a schedule. The following discussion covers the
    Event Scheduler and is divided into the following sections:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="events-overview.html" title="27.4.1 Event Scheduler Overview">
       Section 27.4.1, “Event Scheduler Overview”
      </a>
      , provides an introduction to
        and conceptual overview of MySQL Events.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="events-syntax.html" title="27.4.3 Event Syntax">
       Section 27.4.3, “Event Syntax”
      </a>
      , discusses the SQL statements
        for creating, altering, and dropping MySQL Events.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="events-metadata.html" title="27.4.4 Event Metadata">
       Section 27.4.4, “Event Metadata”
      </a>
      , shows how to obtain
        information about events and how this information is stored by
        the MySQL Server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="events-privileges.html" title="27.4.6 The Event Scheduler and MySQL Privileges">
       Section 27.4.6, “The Event Scheduler and MySQL Privileges”
      </a>
      , discusses the privileges
        required to work with events and the ramifications that events
        have with regard to privileges when executing.
     </p>
    </li>
   </ul>
  </div>
  <p>
   Stored routines require the
   <code class="literal">
    events
   </code>
   data
    dictionary table in the
   <code class="literal">
    mysql
   </code>
   system database.
    This table is created during the MySQL 8.4 installation
    procedure. If you are upgrading to MySQL 8.4 from an
    earlier version, be sure to perform the upgrade procedure to make
    sure that your system database is up to date. See
   <a class="xref" href="upgrading.html" title="Chapter 3 Upgrading MySQL">
    Chapter 3,
    <i>
     Upgrading MySQL
    </i>
   </a>
   .
  </p>
  <h3>
   <a name="idm46045082251744">
   </a>
   Additional Resources
  </h3>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      There are some restrictions on the use of events; see
      <a class="xref" href="stored-program-restrictions.html" title="27.8 Restrictions on Stored Programs">
       Section 27.8, “Restrictions on Stored Programs”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Binary logging for events takes place as described in
      <a class="xref" href="stored-programs-logging.html" title="27.7 Stored Program Binary Logging">
       Section 27.7, “Stored Program Binary Logging”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      You may also find the
      <a class="ulink" href="https://forums.mysql.com/list.php?20" target="_blank">
       MySQL User Forums
      </a>
      to be helpful.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
