- 论坛徽章:
- 0
|
Setting Job Arguments
After creating a job, you may need to set job arguments if:
*
The inline job action is a stored procedure or other executable that requires arguments
*
The job references a named program object and you want to override one or more default program arguments
*
The job references a named program object and one or more of the program arguments were not assigned a default value
To set job arguments, use the SET_JOB_ARGUMENT_VALUE or SET_JOB_ANYDATA_VALUE procedures or Enterprise Manager. SET_JOB_ANYDATA_VALUE is used for complex data types that must be encapsulated in an ANYDATA object.
An example of a job that might need arguments is one that starts a reporting program that requires a start date and end date. The following code example sets the end date job argument, which is the second argument expected by the reporting program:
BEGIN
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
job_name => 'ops_reports',
argument_position => 2,
argument_value => '12-DEC-03');
END;
/
Using the Scheduler (9 October 2009)
[url]http://download.orac |
|