|
|
[ÀϹÝ] DBMS_JOBÀÇ È°¿ë - ÀâÅ¥ÀÇ È®ÀÎ ¹× ½ÃÀÛ ¹× Á¦°Å |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:3944 |
|
|
select job, last_date, last_sec, broken from user_jobs; -- job ½ÇÇà¿©ºÎÈ®ÀÎ
exec dbms_job.broken( jobno, true ); --ÇϽøé ÇØ´ç jobÀ» disable
exec dbms_job.remove( jobno); --ÇϽøé ÇØ´ç jobÀ» ¿ÏÀüÈ÷ Á¦°Å
|
|
|
|