{"id":390,"date":"2011-04-21T17:59:24","date_gmt":"2011-04-21T17:59:24","guid":{"rendered":"http:\/\/10sa.com\/sql_stories\/?p=390"},"modified":"2011-04-21T17:59:24","modified_gmt":"2011-04-21T17:59:24","slug":"event-scheduler-the-classification","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=390","title":{"rendered":"Event Scheduler &#8211; the classification."},"content":{"rendered":"<p>MySQL Server derives its own CRON from version 5.1.6. It is a relevant mechanism like DBMS_SCHEDULER | DBMS_JOB in Oracle or CRON on unix. This feature is perfect for DBA. I use it once it was introduced but now the time has come to classify them conforming to their function.<br \/>\n1. Maintenance (OPTIMIZE, ANALYZE, etc.);<br \/>\n2. ETL (fulfill new structures with extracted data, e.g. ROLAP);<br \/>\n3. Data Modification (operations DML on data conforming to your data flow model);<br \/>\n4. Archiving (moving data into archive tables);<\/p>\n<p>Now, I can use the prefix for the event for better administrating.<br \/>\n1. Maintenance &#8211; mntn_;<br \/>\n2. ETL &#8211; etl_;<br \/>\n3. Data Management dm_;<br \/>\n4. Archiving &#8211; arch_<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Server derives its own CRON from version 5.1.6. It is a relevant mechanism like DBMS_SCHEDULER | DBMS_JOB in Oracle or CRON on unix. This feature is perfect for DBA. I use it once it was introduced but now the time has come to classify them conforming to their function. 1. Maintenance (OPTIMIZE, ANALYZE, etc.); [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,3],"tags":[],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/390"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=390"}],"version-history":[{"count":6,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions"}],"predecessor-version":[{"id":397,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions\/397"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=390"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}