\u00a0grant execute on ELOAN.QLSJ_TRANSCONCURCONTROL to eloan; \u00a0--\u5b58\u50a8\u8fc7\u7a0b\u5355\u72ec\u6388\u6743<\/p>\n
\u00a0--\u521b\u5efaJOB<\/p>\n
\u00a0BEGIN
\n\u00a0sys.dbms_scheduler.create_job(
\n\u00a0job_name => ' ELOAN . QLSJ_TRANSCONCURCONTROL_1 ',
\n\u00a0job_type => 'STORED_PROCEDURE',
\n\u00a0job_action => 'QLSJ_TRANSCONCURCONTROL', \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 --\u5b58\u50a8\u8fc7\u7a0b
\n\u00a0repeat_interval => 'FREQ=MINUTELY;INTERVAL=10', \u00a0 \u00a0 \u00a0 \u00a0 --10\u5206\u949f\u6267\u884c\u4e00\u6b21
\n\u00a0start_date => systimestamp at time zone '+8:00',
\n\u00a0job_class => ' DEFAULT_JOB_CLASS ',
\n\u00a0auto_drop => FALSE,
\n\u00a0enabled => FALSE);
\n\u00a0sys.dbms_scheduler.set_attribute( name => ' ELOAN . QLSJ_TRANSCONCURCONTROL_1 ', attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
\n\u00a0sys.dbms_scheduler.enable( ' ELOAN . QLSJ_TRANSCONCURCONTROL_1 ' );
\n\u00a0end;<\/p>\n
\u00a0 select from dba_scheduler_jobs a where \u00a0a.JOB_NAME='QLSJ_TRANSCONCURCONTROL_1'; \u00a0 \u00a0 \u00a0--\u67e5\u770bjob\u7b56\u7565 \u00a0grant execute on ELOAN.Q<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1285","post","type-post","status-publish","format-standard","hentry","category-oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1285"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1285\/revisions"}],"predecessor-version":[{"id":1287,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1285\/revisions\/1287"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1285"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u00a0 select <\/em> from dba_scheduler_job_run_details a where a.JOB_NAME='QLSJ_TRANSCONCURCONTROL_1'; \u00a0 \u00a0--\u67e5\u770bjob\u6267\u884c\u8bb0\u5f55 \u00a0 \u00a0 \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"