Oracle PL/SQL Programming: A Developer's Workbook

Expert

25-39.	You have a job (#47) that has been running an incredibly long time, and you want to stop it. How can you do this?
25-40.	Write a procedure called run_job that simplifies the process of submitting a job that runs at a predefined time for a specific day. For example, the program makes it easy to submit a job that runs every Monday and Friday at 11:00 P.M. The procedure should accept a job number (like ISUBMIT), the job, an initial execution date, a single start time, and a string representing the days on which the job is to run. This last string should accept a comma-delimited list of ordinal days of the week (i.e., 0=Sunday, 1=Monday,…6=Saturday). If the user does not specify a set of days, the job should be scheduled to run every day of the week. Use the following header: CREATE OR REPLACE PROCEDURE run_job ( job IN VARCHAR2, job_text VARCHAR2 DEFAULT 'begin NULL; end;', next_date DATE DEFAULT SYSDATE, extime VARCHAR2 DEFAULT '13', exdays VARCHAR2 DEFAULT NULL )
25-41.	Why is the next_date parameter declared differently in the SUBMIT and ISUBMIT procedures?