{"id":1312,"date":"2016-03-24T04:38:12","date_gmt":"2016-03-24T04:38:12","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1312"},"modified":"2016-03-24T04:38:12","modified_gmt":"2016-03-24T04:38:12","slug":"oracle-db-scheduler-%ea%b0%9c%eb%85%90-%eb%b0%8f-%ec%82%ac%ec%9a%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1312","title":{"rendered":"Oracle DB Scheduler \uac1c\ub150 \ubc0f \uc0ac\uc6a9\ubc95"},"content":{"rendered":"<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Oracle DB Scheduler \uac1c\ub150        \ubc0f \uc0ac\uc6a9\ubc95<br \/>\n<\/strong><\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 <strong>\ubaa9\uc801.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database\ub0b4 \ud639\uc744 Database Server\uc5d0\uc11c \uc815\uaddc, \ube44\uc815\uaddc \uc791\uc5c5\uc744 \uc218\ud589 .<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 <strong>\uc0ac\uc6a9 \uc6a9\ub3c4<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database \ud1b5\uacc4\uce58 \uc218\uc9d1 \uc791\uc5c5 \uc77c \ub9c8\uac10 \uc791\uc5c5<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Backup \uc791\uc5c5<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database\ub0b4\uc758 \uc815\uc8fc\uae30 \uc791\uc5c5<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Server\ub0b4\uc758 \uc815\uc8fc\uae30 \uc791\uc5c5<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 <strong>\ud2b9\uc9d5<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">9i\uc774\uc804\uc758 job queue\uc758 \uac1c\uc120\ub41c \uae30\ub2a5\uc73c\ub85c Scheduler\uc5d0\uc11c job queue\uc758 \uae30\ub2a5\ub3c4 \ud3ec\ud568\ud568. \ub2e4\uc591\ud55c \ud504\ub85c\uadf8\ub7a8\uc744 \ub4f1\ub85d\ud558\uc5ec \uc218\ud589 \uac00\ub2a5.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">PL\/SQL stored procedure Anonymous PL\/SQL block<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">External Executable program(shell, os command\ub4f1)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">EM\uc758 UI \ud654\uba74 \uc81c\uc5b4 \ud639\uc740 DBMS_SCHEDULER API\ub97c \uc774\uc6a9\ud55c \uc81c\uc5b4. Job\uc5d0 \ub300\ud55c Priority \uc9c0\uc815 \ubc0f \uc218\ud589\ud560\uc218 \uc788\ub294 Time Window \uc9c0\uc815 \uae30\ub2a5.<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<h2><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Architecture<br \/>\n<\/span><\/h2>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Program : \uc218\ud589\ub420 \ud504\ub85c\uadf8\ub7a8 \ubc0f argument \uc815\uc758<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Job : \uc5b4\ub5a0\ud55c \uac83\uc744 \uc5b8\uc81c \uc218\ud589\ud560\uc9c0\ub97c \uc815\uc758<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Schedule : \uc218\ud589 \uc2dc\uae30 \ubc0f \ubc18\ubcf5 \uc8fc\uae30 \uc815\uc758<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Job Class : job\ub4e4\uc758 \uce74\ud14c\uace0\ub9ac\uc758 \uad6c\ubd84 \uc815\uc758.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Window : Job\uc758 \uc218\ud589 \uac00\ub2a5 \uc2dc\uac04 \uad6c\uac04\uc744 \uc815\uc758<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Window group : Window\ub4e4\uc758 \uc9d1\ud569\uc73c\ub85c \uc5ec\ub7ec \uad6c\uac04 \uc815\uc758 \uc2dc \uc0ac\uc6a9<br \/>\n<\/strong><\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"margin-left: 41pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Resource Consumer Group : job\uacfc \uc6b0\uc120 \uc21c\uc704 \uc815\uc758\uc640\uc758 \uc5f0\uacb0\uc815\uc758<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 41pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Resource Plan : \uc790\uc6d0\uc5d0 \ub300\ud55c \uc6b0\uc120\uc21c\uc704 \uc815\uc758(cpu\ub4f1)<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 41pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 41pt\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.2233AF3A56F36F333546D5.png?w=640\" align=\"left\" data-recalc-dims=\"1\"\/><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 41pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 41pt\">\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 41pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 <strong>\ud544\uc694 \uad8c\ud55c<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">Create Job <\/span>: job, schedule, program\uc744 \ub9cc\ub4e4\uae30 \uc704\ud55c \uad8c\ud55c.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">Manager Scheduler <\/span>: window, job class, window group\uc744 \ub9cc\ub4e4\uae30 \uc704\ud55c \uad8c\ud55c<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 47pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">EXECUTE ON <\/span>&lt;program or class&gt; : \uc77c\ubc18 User\uac00 program\uc5d0 \ub300\ud55c \uc218\ud589\ud558\uae30 \uc704\ud55c \uad8c\ud55c \uc8fc\uae30.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 32pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 32pt\">\n&nbsp;<\/p>\n<h2><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 SCHEDULER_ADMIN Role<br \/>\n<\/span><\/h2>\n<p style=\"margin-left: 32pt\">\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile10.uf.272D493C56F36F342B77ED.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><br \/>\n\t\t<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"margin-left: 5pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Job Runtime Structure<br \/>\n<\/strong><\/span><\/p>\n<p>\n&nbsp;<\/p>\n<h3><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0&nbsp;&nbsp;&nbsp;&nbsp;\uc815\uc758\ub41c Job\uc5d0 \ub300\ud55c \uc218\ud589 \ubc29\ubc95.<br \/>\n<\/span><\/h3>\n<p style=\"margin-left: 44pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>\uc9c0\uc815\ub41c Job\uc5d0 \ub300\ud55c \uc218\ud589\uc740 CJQ process\uac00 check\ud558\uc5ec \uc218\ud589\ub420 job\uc744 job slave process\uc5d0\uac8c \uc9c0\uc815 \ud55c\ub2e4.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 44pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 44pt\">&nbsp;<\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile27.uf.230DCB3E56F36F342B74CC.png?w=640\" align=\"left\" data-recalc-dims=\"1\"\/><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/>\n\t\t\t<\/strong><\/span><\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><br \/><\/strong><\/span><\/p>\n<p><font face=\"\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 13.3333px; line-height: 20px;\"><b>Create a Program<\/b><\/span><\/font><\/p>\n<p><font face=\"\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size: 13.3333px; line-height: 20px;\"><b><br \/><\/b><\/span><\/font><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>\uc218\ud589 \ud560  Program\uc774\ub098 Shell, PL\/SQL\uc744 &#8216;Program&#8217;\uc73c\ub85c \ub4f1\ub85d\ud55c\ub2e4.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">BEGIN<\/span><br \/>\n\t\t<\/span><\/p>\n<p>&nbsp; &nbsp;<span style=\"color: rgb(255, 51, 0); font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; line-height: 1.5;\">DBMS_SCHEDULER.CREATE_PROGRAM (<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">program_name =&gt; &#8216;TDDBA.TEST_PRG&#8217;,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">program_action =&gt; &#8216;\/DBMS\/TMASG\/DBA\/TDDBA\/test.sh&#8217;, program_type =&gt; &#8216;EXECUTABLE&#8217;,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">enabled =&gt; TRUE, number_of_arguments =&gt; 0, comments =&gt; &#8216;Test shell program&#8217;);<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 11pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">END;<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">\/<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 11pt\"><\/p>\n<p style=\"margin-left: 11pt\"><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc124\uba85&nbsp;&nbsp;&nbsp;&nbsp;: test.sh\uc774\ub77c\ub294 os shell\uc744 \uc218\ud589\ud558\ub294 program\ub4f1\ub85d.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">Program_type <\/span>: \ub4f1\ub85d\ud558\ub294 program\uc758 type\uc744 \uc815\uc758. &#8216;EXECUTABLE&#8217;, &#8216;plsql_block&#8217;,&#8217; stored_procedure &#8216; \ub4f1\uc774 \uc788\uc74c.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">Enabled <\/span>:  program\uc5d0 \ub300\ud55c validate check\ub97c \ud558\uba70 \ub610\ud55c \ubc14\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 enable\uc0c1\ud0dc\ub85c \ub9cc\ub4e0\ub2e4.<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<h2><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u25a0 \uc791\uc5c5\uc5d0 \ub300\ud55c \uc218\ud589 \uc8fc\uae30, \ubc18\ubcf5 \ub4f1\uc758 \uc815\uc758\ud55c\ub2e4.<br \/>\n<\/span><\/h2>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<\/span><br \/>\n\t\t<span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_SCHEDULE(<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt; &#8216;min_job_schedule&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212; start_date =&gt; SYSTIMESTAMP,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212; end_date =&gt; SYSTIMESTAMP + 30,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval =&gt; &#8216;FREQ=MINUTELY;INTERVAL=30&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt; &#8216;Every 30 min&#8217;);<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"color:#ff3300; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">\/<\/span><br \/>\n\t\t<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc124\uba85 : 30\ubd84\ub9c8\ub2e4 \uc218\ud589\ud558\ub294 \uacc4\ud68d\uc744 \uc790\uae34 min_job_schedule \uc774\ub77c\ub294 schedule \uc0dd\uc131. <span style=\"color:#6699ff\">Repeat_interval <\/span>: Schedule\uc758 \ubc18\ubcf5 \uc2dc\uac04\uc740 \uc9c0\uc815.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 155pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ex) repeat_interval=&gt; &#8216;FREQ=HOURLY; INTERVAL=4&#8217; 4\uc2dc\uac04 \ub9c8\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 106pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval=&gt; &#8216;FREQ=DAILY&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 155pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ud558\ub8e8\ub9c8\ub2e4<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 155pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval=&gt; &#8216;FREQ=MINUTELY; INTERVAL=15&#8217; 15\ubd84 \ub9c8\ub2e4<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 106pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval=&gt; &#8216;FREQ=YEARLY; BYMONTH=MAR,JUN,SEP,DEC; BYMONTHDAY=15&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 155pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ub9e4\ub144, 3,6,9,12\uc6d4 15\uc77c\uc5d0.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 106pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval=&gt; &#8216;SYSDATE + 6\/24&#8217; repeat_interval=&gt; &#8216;SYSDATE + 1&#8217; repeat_interval=&gt; &#8216;SYSDATE + 15\/(24*60)&#8217;<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 32pt\">\n&nbsp;<\/p>\n<h2><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Job Class\ub97c \ub4f1\ub85d \ud55c\ub2e4.<br \/>\n<\/span><\/h2>\n<p style=\"margin-left: 32pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">begin<\/span><br \/>\n\t\t<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">DBMS_SCHEDULER.CREATE_JOB_CLASS (<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">job_class_name&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;TEST_JOB_CLASS&#8217;,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">&#8212;&nbsp;&nbsp;&nbsp;&nbsp;resource_consumer_group&nbsp;&nbsp;&nbsp;&nbsp;IN VARCHAR2 DEFAULT NULL,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">&#8212;&nbsp;&nbsp;&nbsp;&nbsp;service&nbsp;&nbsp;&nbsp;&nbsp;IN VARCHAR2 DEFAULT NULL,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">logging_level&nbsp;&nbsp;&nbsp;&nbsp;=&gt; DBMS_SCHEDULER.LOGGING_FULL, log_history&nbsp;&nbsp;&nbsp;&nbsp;=&gt;1,<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">comments&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;test&#8217;);<\/span><br \/>\n\t\t<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">end;<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">\/<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 11pt\">\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc124\uba85 : TesT_job_class\ub77c\ub294 job class\ub85c\uc774 class\uc5d0 \ud3ec\ud568\ub41c job\uc740 logging level\uc774 logging_full\uc774\uace0 1\uc77c \ub3d9\uc548 log\uae30 \ub85d\uc774 \ubcf4\uc874\ub41c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><span style=\"color:#6699ff\">Service <\/span>: \uc774 job class\uc5d0 \uc18d\ud55c job\uc774 \ud3ec\ud568\ub418\ub294 Service\ub97c \uba85\uc2dc.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><span style=\"color:#6699ff\">Logging Level : <\/span>\uc774 Job Class\uc5d0 \uc18d\ud55c Job\uc758 logging level\uc744 \uc815\ud558\ub294 \uac83\uc73c\ub85c<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>LOGGING_FULL, LOGGING_RUNS,<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>LOGGING_OFF 3\uac00\uc9c0\uac00 \uc9c0\uc6d0\ub41c\ub2e4.<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><span style=\"color:#6699ff\">Log_history: <\/span>\uc774 job class\uc5d0 \uc18d\ud55c job\uc758 log\ub97c \ubcf4\uc874\ud558\ub294 \uae30\uac04\uc744 \uc815\uc758\ud55c\ub2e4. Default value\ub294 30\uc77c \uc774\ub2e4.<br \/>\n<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB (<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_name&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;TDDBA.TEST_JOB&#8217;, program_name&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;TDDBA.TEST_PRG&#8217;, schedule_name&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;min_job&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;TEST_JOB_CLASS&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled&nbsp;&nbsp;&nbsp;&nbsp;=&gt;TRUE);<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#6699ff\">Program_name <\/span>: job\uc5d0\uc11c \uc0ac\uc6a9\ud560 program <span style=\"color:#6699ff\">Schedule_name <\/span>: job\uc744 \uc218\ud589\ud560 \uc8fc\uae30 schedule <span style=\"color:#6699ff\">Job_class <\/span>: job\uc758 \uc18d\uc131\uc744 \uc815\uc758\ud55c class<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ucc38\uace0 : dbms_scheduler.set_attribute\ub97c \uc774\uc6a9\ud558\uc5ec job\uc5d0 \ub300\ud574 \uc9c0\uc815\ud560 \uc218 \uc788\ub294 attribute\ub4e4<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class job_priority auto_drop restartable max_runs max_failures schedule_limit logging_level<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB(<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_name&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;TDDBA.TEST_JOB&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_type&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;EXECUTABLE&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_action&nbsp;&nbsp;&nbsp;&nbsp;=&gt;&#8217;\/DBMS\/TMASG\/DBA\/TDDBA\/test.sh&#8217;, start_date&nbsp;&nbsp;&nbsp;&nbsp;=&gt; sysdate+1\/24,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;SYSDATE + 1800\/86400&#8217;, job_class&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;TEST_JOB_CLASS&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled&nbsp;&nbsp;&nbsp;&nbsp;=&gt; TRUE,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 83pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments&nbsp;&nbsp;&nbsp;&nbsp;=&gt; &#8216;test job&#8217;);<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 11pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc124\uba85 : test.sh shell\uc744 \ud558\ub8e8 \ud6c4\ubd80\ud130 30\ubd84 \ub9c8\ub2e4 \uc218\ud589\ud558\ub294 job \ub4f1\ub85d.<br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<h3><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">1. os\uc758 shell program\uc740 extjob\uc5d0 \uc758\ud574 \uc218\ud589\ub418\ub294\ub370 \uc774\ub97c nobody user\uac00 \uc218\ud589\ud560\uc218 \uc788\ub3c4\ub85d \uc9c0\uc815.<br \/>\n<\/span><\/h3>\n<ul style=\"margin-left: 46pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>$ORACLE_HOME\/bin\/extjob \uc774 \uc218\ud589\ud558\uac8c \ub418\ub294\ub370, \uc774\ub294 nobody owner\ub85c \uc9c0\uc815\ud558\uac8c \ub41c\ub2e4.<br \/>\n<\/strong><\/span><\/div>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 3pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ls \u2013l extjob* (IBM)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 7pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">-rws&#8211;s&#8211;x&nbsp;&nbsp;&nbsp;&nbsp;1 nobody&nbsp;&nbsp;&nbsp;&nbsp;nobody&nbsp;&nbsp;&nbsp;&nbsp;624382 Apr  6 15:12 extjob<\/span><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<\/ul>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<ul style=\"margin-left: 46pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>HP \uc5d0\uc11c\ub294 nobody\ub85c owner\uac00 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc77c\ubc18 user( unprivileged user)\uac00 owner\uac00 \ub418\ub3c4\ub85d \ud55c\ub2e4.<br \/>\n<\/strong><\/span><\/div>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 3pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ls \u2013l extjob* (hp) : oranbody user\ub97c \uc0dd\uc131\ud558\uace0 ownership \ubc14\uafbc\ud6c4 mode\ub97c 4711\ub85c \ubcc0\uacbd.<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color:#ff3300\">-rws&#8211;x&#8211;x&nbsp;&nbsp;&nbsp;&nbsp;1 oranbody&nbsp;&nbsp;&nbsp;&nbsp;dbusers&nbsp;&nbsp;&nbsp;&nbsp;33936 Jun 11 18:13 extjob<\/span><br \/>\n\t\t\t\t<\/span><\/p>\n<p style=\"margin-left: 3pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 3pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle install \ubb38\uc11c \ucc38\uace0 :<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 39pt\"><a href=\"http:\/\/download-west.oracle.com\/docs\/html\/B10811_02\/ch4.htm\"><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt; text-decoration:underline\">http:\/\/download-west.oracle.com\/docs\/html\/B10811_02\/ch4.htm#sthref1606<\/span><\/a><span style=\"color:red; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<\/ul>\n<p>\n&nbsp;<\/p>\n<p>\n&nbsp;<\/p>\n<h3><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><a name=\"2._Install_._root.sh_..\">2. Install \uc791\uc5c5\uc2dc \ucd94\uac00 \uc0ac\ud56d. root.sh \uc774\ud6c4\uc5d0..<br \/>\n<\/a><\/span><\/h3>\n<p style=\"margin-left: 46pt\"><a name=\"2._Install_._root.sh_..\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"># cd oracle_home\/bin<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"2._Install_._root.sh_..\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"># mv extjob.nobody extjob<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"2._Install_._root.sh_..\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"># chown nobody extjob<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"2._Install_._root.sh_..\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"># chmod 4711 extjob<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"2._Install_._root.sh_..\"><br \/>\n&nbsp;<\/a><\/p>\n<h3><a name=\"2._Install_._root.sh_..\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><\/span><\/a><a name=\"3._Shell_.\">3. Shell \ub0b4\uc6a9.<br \/>\n<\/a><\/h3>\n<p style=\"margin-left: 46pt\"><a name=\"3._Shell_.\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">shell\uc758 \uccab \ub77c\uc778\uc740 shell\uc744 \uc9c0\uc815\ud558\ub294 #!\/usr\/bin\/ksh \ub97c \uc9c0\uc815\ud574\uc57c \ud568. shell\ub0b4\uc758 \ubaa8\ub4e0 command\ub294 path\ub97c \uc54c \uc218 \uc788\ub3c4\ub85d \uc9c0\uc815.<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"3._Shell_.\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ex) test.sh<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"3._Shell_.\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#!\/usr\/bin\/ksh<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 46pt\"><a name=\"3._Shell_.\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/usr\/bin\/ls -ltr &gt; \/dbms\/tkmasg\/dba\/TDDBA\/a.out<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"3._Shell_.\">&nbsp;<\/a><\/p>\n<p><a name=\"3._Shell_.\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"3._Shell_.\"><br \/>\n&nbsp;<\/a><\/p>\n<h3><a name=\"3._Shell_.\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><\/span><\/a><a name=\"1_Scheduler_View\">1 Scheduler\uad00\ub828 View<br \/>\n<\/a><\/h3>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOBS&nbsp;&nbsp;&nbsp;&nbsp;: \ub4f1\ub85d\ub41c job<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_ARGS&nbsp;&nbsp;&nbsp;&nbsp;: job\uc758 arguments<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_RUNNING_JOBS&nbsp;&nbsp;&nbsp;&nbsp;: \ud604\uc7ac running\uc911\uc778 job\ub4e4\uc758 \uc815\ubcf4<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_LOG&nbsp;&nbsp;&nbsp;&nbsp;: job\uc758 log<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_RUN_DETAILS&nbsp;&nbsp;&nbsp;&nbsp;: job\uc758 \uc218\ud589\ub41c \uc815\ubcf4 \ubc0f Error \uc815\ubcf4<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_PROGRAMS  [DBA | ALL | USER]_SCHEDULER_PROGRAM_ARGS [DBA | ALL | USER]_SCHEDULER_SCHEDULES [DBA | ALL]_SCHEDULER_JOB_CLASSES<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL ]_SCHEDULER_WINDOWS<br \/>\n<\/span><\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL ]_SCHEDULER_WINDOW_DETAILS [DBA | ALL ]_SCHEDULER_WINDOW_LOG<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p style=\"margin-left: 11pt\"><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">2. ETC command<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">1 Scheduler \uad00\ub828 View<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOBS :  \ub4f1\ub85d\ub41c job<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_ARGS : job\uc758 \uc758 arguments<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_RUNNING_JOBS :  \ud604\uc7ac running \uc911\uc778 job \ub4e4\uc758 \uc815 \ubcf4<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_LOG : job\uc758 \uc758 log<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_JOB_RUN_DETAILS : job \uc758 \uc218\ud589\ub41c \uc815\ubcf4 \ubcf4 \ubc0f \ubc0f Error  \uc815 \ubcf4<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_PROGRAMS<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_PROGRAM_ARGS<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL | USER]_SCHEDULER_SCHEDULES<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL]_SCHEDULER_JOB_CLASSES<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL ]_SCHEDULER_WINDOWS<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL ]_SCHEDULER_WINDOW_DETAILS<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[DBA | ALL ]_SCHEDULER_WINDOW_LOG<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">2. ETC command<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec DBMS_SCHEDULER.enable(&#8216;TDDBA.TEST_JOB&#8217;)  : job enable \uc2dc \ud0a4 \uae30.<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec DBMS_SCHEDULER.DISABLE(&#8216;TDDBA.TEST_JOB&#8217;) : job disable \uc2dc \ud0a4 \uae30.<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec DBMS_SCHEDULER.DROP_JOB(&#8216;TDDBA.TEST_JOB&#8217;); : job drop<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec dbms_scheduler.drop_schedule(&#8216;min_job&#8217;); : schedule drop<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec dbms_Scheduler.drop_program(&#8216;TDDBA.TEST_PRG&#8217;);: program drop<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec DBMS_SCHEDULER.RUN_JOB(&#8216;TDDBA.TEST_JOB&#8217;) : manual run a job<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Exec DBMS_SCHEDULER.PURGE_LOG(log_history =&gt; 1, job_name =&gt; &#8216;DEV_TEST_JOB1&#8217;); : log<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">Sample job with anonymous PL\/SQL<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">1. Job Class \uc0dd\uc131<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB_CLASS (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class_name =&gt;&#8217;PLSQL_BLOCK_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">logging_level =&gt;DBMS_SCHEDULER.LOGGING_FULL,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">log_history =&gt;1,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt;&#8217;plsql block job class&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">2. Program  \uc0dd\uc131<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_PROGRAM(<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt; &#8216;INSERT_DEPT_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_type =&gt; &#8216;PLSQL_BLOCK&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_action =&gt;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;DECLARE<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">v_cnt number;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">v_cnt := 1;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">while v_cnt &lt; 11 loop<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">insert into TDDBA.dept values (v_cnt, &#8221;aaa&#8221;,&#8221;ggg&#8221;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">commit;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">v_cnt := v_cnt + 1;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end loop;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled  =&gt; TRUE);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">3. Schedule  \uc0dd\uc131<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_SCHEDULE(<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt; &#8216;min_30_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval =&gt; &#8216;FREQ=MINUTELY;INTERVAL=30&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt; &#8216;Every 30 min&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">4. Job \uc0dd\uc131<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_name =&gt;&#8217;TDDBA.INSERT_DEPT_JOB&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt;&#8217;TDDBA.INSERT_DEPT_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt;&#8217;min_30_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class =&gt;&#8217;PLSQL_BLOCK_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled =&gt;TRUE);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">5. Testing.<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size:10pt\">exec DBMS_SCHEDULER.RUN_JOB(&#8216;TDDBA.INSERT_DEPT_JOB&#8217;);<\/span><br \/>\n\t\t<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">Sample job with O\/S Shell program<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB_CLASS (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class_name =&gt;&#8217;TEST_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">logging_level =&gt;DBMS_SCHEDULER.LOGGING_FULL,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">log_history =&gt;1,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt;&#8217;test&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_PROGRAM (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt; &#8216;TDDBA.TEST_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_action =&gt; &#8216;\/usr\/bin\/sh \/DBMS\/TMASG\/DBA\/TDDBA\/test.sh&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_type =&gt; &#8216;EXECUTABLE&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled =&gt; TRUE,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt; &#8216;Test shell program&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_SCHEDULE(<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt; &#8216;min_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval =&gt; &#8216;FREQ=MINUTELY;INTERVAL=10&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments  =&gt; &#8216;Every 10 min&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_name =&gt;&#8217;TDDBA.TEST_JOB&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt; &#8216;TDDBA.TEST_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt; &#8216;min_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class =&gt;&#8217;TEST_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled =&gt;TRUE);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Test.sh<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#!\/usr\/bin\/ksh<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/usr\/bin\/ls -ltr &gt; \/dbms\/tkmasg\/a.out<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">chmod +x test.sh<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\">Sample job with anonymous PL\/SQL<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">CREATE OR REPLACE PROCEDURE TDDBA.TEST_STORED_PLSQL<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">IS<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">UPDATE TDDBA.DEPT SET LOC = &#8216;SEOUL&#8217;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">WHERE ROWNUM =1;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">commit;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB_CLASS (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class_name =&gt;&#8217;PLSQL_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">logging_level =&gt;DBMS_SCHEDULER.LOGGING_FULL,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">log_history =&gt;1,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt;&#8217;procedure job class&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_PROGRAM(<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt; &#8216;TEST_STORED_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_action =&gt; &#8216;TDDBA.TEST_STORED_PLSQL&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_type =&gt; &#8216;STORED_PROCEDURE&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled  =&gt; TRUE);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">END;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">BEGIN<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_SCHEDULE(<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt; &#8216;min_15_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">repeat_interval =&gt; &#8216;FREQ=MINUTELY;INTERVAL=15&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">comments =&gt; &#8216;Every 15 min&#8217;);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">begin<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DBMS_SCHEDULER.CREATE_JOB (<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_name =&gt;&#8217;TDDBA.UPDATE_DEPT_JOB&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">program_name =&gt;&#8217;TDDBA.TEST_STORED_PRG&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">schedule_name =&gt;&#8217;min_15_job&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">job_class =&gt;&#8217;PLSQL_JOB_CLASS&#8217;,<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">enabled =&gt;TRUE);<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">end;<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><br \/>\n&nbsp;<\/a><\/p>\n<p><a name=\"1_Scheduler_View\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">exec DBMS_SCHEDULER.RUN_JOB(&#8216;TDDBA.UPDATE_DEPT_JOB&#8217;);<br \/>\n<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle DB Scheduler \uac1c\ub150 \ubc0f \uc0ac\uc6a9\ubc95 &nbsp; \u25a0 \ubaa9\uc801. Database\ub0b4 \ud639\uc744 Database Server\uc5d0\uc11c \uc815\uaddc, \ube44\uc815\uaddc \uc791\uc5c5\uc744 \uc218\ud589 . &nbsp; \u25a0 \uc0ac\uc6a9 \uc6a9\ub3c4 Database \ud1b5\uacc4\uce58 \uc218\uc9d1 \uc791\uc5c5 \uc77c \ub9c8\uac10 \uc791\uc5c5 Backup \uc791\uc5c5 Database\ub0b4\uc758 \uc815\uc8fc\uae30 \uc791\uc5c5 Database Server\ub0b4\uc758 \uc815\uc8fc\uae30 \uc791\uc5c5 &nbsp; \u25a0 \ud2b9\uc9d5 9i\uc774\uc804\uc758 job queue\uc758 \uac1c\uc120\ub41c \uae30\ub2a5\uc73c\ub85c Scheduler\uc5d0\uc11c job queue\uc758 \uae30\ub2a5\ub3c4 \ud3ec\ud568\ud568. \ub2e4\uc591\ud55c \ud504\ub85c\uadf8\ub7a8\uc744 \ub4f1\ub85d\ud558\uc5ec \uc218\ud589 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1313,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[740,741,742,743,744],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile10.uf.272D493C56F36F342B77ED.png?fit=254%2C199","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1312"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1312"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1312\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1313"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1312"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}