本文介绍了一个使用Oracle DBMS_SCHEDULER创建的作业示例，该作业名为'update_sales'，用于定期执行'SALES_PKG.UPDATE_SALES-SUMMARY'过程。作业被设定为每隔两天运行一次，从2007年12月28日至2008年1月20日。文章还讨论了作业的一些特性，如默认启用状态和到期后自动删除。
QUESTION 74
The user SYS creates a job by using the following command:
BEGIN
DBMS_SCHEDULER.CREATE_JOB ( job_name => 'update_sales',
job_type => 'STORED-PROCEDURE',
job_action => 'OPS.SALES_PKG.UPDATE_SALES-SUMMARY',
start_date => '28-DEC-07 07.00.00 PM Australia/Sydney',
repeat_interval => 'FREQ=DAILY; INTERVAL=2',
end_date => '20-JAN-08 07.00.00 PM Australia/Sydney',
comments => 'New sales job');
END;
/
Which two statements are true about the job that was created by the preceding command? (Choose two.)
A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D. The globalization environment that exists at the time of the job creation prevails at the job runs
Answer: BC
同651题：http://blog.csdn.net/rlhua/article/details/16105705
Explanation/Reference:
Section: SQL, PL/SQL, Packages, Functions, Jobs & Views
扫一扫
9043
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
