我的job如何启动？？？？？？？？？

Question

创建的简单的存储过程：create or replace procedure forumMission
is
begin
dbms_output.put_line('ffff');
end;创建的job每隔1分钟执行一次：declare
  jobno number;
begin
  dbms_job.submit(
job => :jobno ,
what=>'forumMission;',
next_date =>sysdate,
interval =>'sysdate+1/1440'
  );
end;执行：begin
dbms_job.run(v_job);         //运行job就输出了一个fffff;
查看当前运行的job：

SQL> select * from dba_jobs_running;未选定行

Answer 1

需要commit;在你的
begin
  dbms_job.submit(
     );
commit;
end;
/select * from dba_jobs;

Answer 2

commit之后呢，该job就会执行吗？是不是还得：
exec dbms_job.run(XX);
我的这个XX参数是job字段的值？还是？？

Answer 3

SQL> desc user_jobs;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- JOB                                       NOT NULL NUMBER
 LOG_USER                                  NOT NULL VARCHAR2(30)
 PRIV_USER                                 NOT NULL VARCHAR2(30)
 SCHEMA_USER                               NOT NULL VARCHAR2(30)
 LAST_DATE                                          DATE
 LAST_SEC                                           VARCHAR2(8)
 THIS_DATE                                          DATE
 THIS_SEC                                           VARCHAR2(8)
 NEXT_DATE                                 NOT NULL DATE
 NEXT_SEC                                           VARCHAR2(8)
 TOTAL_TIME                                         NUMBER
 BROKEN                                             VARCHAR2(1)
 INTERVAL                                  NOT NULL VARCHAR2(200)
 FAILURES                                           NUMBER
 WHAT                                               VARCHAR2(4000)
 NLS_ENV                                            VARCHAR2(4000)
 MISC_ENV                                           RAW(32)
 INSTANCE                                           NUMBER是这个第一个的job字段？？

Answer 4

没有commit也创建了，查看如下：SQL> select job from user_jobs;       JOB
----------
         1
         2
         3