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

TOADLover

RT
上图：
-----------

------------
图中的参数应该怎么传递，比如20090305000000 这个字符型时间怎么传进去？

RPT是一个包
e_per_rpt是个存储过程， 接收两个varchar2型参数，我想传递两个''给这两个参数，应该怎么做？

[ 本帖最后由 TOADLover 于 2009-10-12 09:38 编辑 ]

rollingpig

就用DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE 啊~
上面已经举例了
BEGIN
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (
   job_name                => 'ops_reports',
   argument_position       => 2,
   argument_value          => '12-DEC-03');
END;

TOADLover

怎么了？

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

TOADLover

原帖由 ziggler 于 2009-10-9 15:45 发表
job_name => 'ops_reports', argument_position => 2, argument_value => '12-DEC-03');
Using the Scheduler (9 October 2009)
http://download.oracle.com/docs/ ... 02/b14231/scheduse. ...

----------
谢谢。

可是这份文档，说的都是不常用的。
最常用的job_type 是store Procedure，却没有提到啊：

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
   job_name                 =>  'my_new_job2',
   job_type                 =>  'PLSQL_BLOCK',
   job_action               =>  'BEGIN SALES_PKG.UPDATE_SALES_SUMMARY; END;',
   schedule_name            =>  'my_saved_schedule');
END;
/


而且这里也没提到如何用单引号的问题？？？？

ziggler

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


提到了啊

TOADLover

谢谢Ziggler回帖，感谢。

我想问问：

schedule.job的job action 怎么传递Procedure的参数呢？ 比如我在一楼贴的图，怎么传递两个''空给这个Procedure呢？

TOADLover

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