schedule.job的job action 怎么传递Procedure的参数？

ziggler

job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',
Using the Scheduler (9 October 2009)
http://download.oracle.com/docs/ ... heduse.htm#i1009668

ziggler

job_name => 'ops_reports', argument_position => 2, argument_value => '12-DEC-03');
Using the Scheduler (9 October 2009)
http://download.oracle.com/docs/ ... heduse.htm#i1009668

自己通过连接看吧，我想给你拷贝过来，CU上发不上去。

ziggler

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

ziggler

job_type => 'STORED_PROCEDURE',
Using the Scheduler (9 October 2009)
http://download.oracle.com/docs/ ... heduse.htm#i1009668


提到了啊

ziggler

BEGIN
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
   job_name                => 'ops_reports',
   argument_position       => 2,
   argument_value          => '12-DEC-03');
END;

这种方式不可以吗？