查看oracle创建的任务计划的job

How to find the job name if a scheduled job fails with ORA-12012

When a scheduled job fails, the alert log shows an error message like:
"ORA-12012 error on auto execute of job 47544".

How do I correlate the job number value in the alert log to the job name
listed in dba_scheduler_jobs?


Solution
The usage of finding out job information for Scheduler Jobs is different than the usage of the old Job mechanism.

In both cases ( DBMS_SCHEDULER and DBMS_JOB) the alert.log will show you an error when the job failed.

Example:
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_3036.trc:
ORA-12012: error on auto execute of job 54887
ORA-06550: line ORA-06550: line 1, column 417:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 405:
PL/SQL: SQL Statement ignored
, column :

where the number in the error message is the job identifier.


For DBMS_JOB usage:
To find out more information about that failing job you can simply go over the jobnumber and select the needed information from the view dba_jobs.


SQL>select job, what from dba_jobs ;
JOB WHAT
---------- ----------------------------------------------------------
1 EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
21 BEGIN MGMT_BSLN.COMPUTE_ALL_STATISTICS;/*DB*/END;
22 BEGIN MGMT_BSLN.SET_ALL_THRESHOLDS;/*DB*/END;
Note: The job does not have a job_name when dbms_job is used.

 


For DBMS_SCHEDULER usage:
For the application user the usage of scheduled jobs is now more defined by the name of the job and not by the job identifier.
Unfortunal the error message ORA-12012 will not show you the name of the job, but will still show you the job identifier.
This job identifier is now more dictionary information and correlates to the object_id from the view dba_objects

The job identifier is stored in the table sys.scheduler$_job under column obj#.

When a relation for the job identifier to the job name is needed then the following select statement can help:

 

select obj# , object_name from sys.scheduler$_job , dba_objects
where obj# = object_id;


 

Example:

SQL> select obj# , object_name from sys.scheduler$_job , dba_objects
2 where obj# = object_id;

OBJ# OBJECT_NAME
---------- ----------------------------
54888 RUNTEST_JOB
54869 RUNTEST_JOB

Having the name of the job you can select the relevant scheduler views like DBA_SCHEDULER_JOB_RUN_DETAILS
to find out more infomation like the status , or the additional information for the scheduled job.

As an alternative, the generated job trace file can be viewed to find out the related job name:

Example:
orcl_j000_3036.trc:
------------------------
....
*** ACTION NAME:(RUNTEST_JOB) 2008-10-21 09:14:30.165
*** MODULE NAME:(DBMS_SCHEDULER) 2008-10-21 09:14:30.165
*** SERVICE NAME:(SYS$USERS) 2008-10-21 09:14:30.165
*** SESSION ID:(145.37) 2008-10-21 09:14:30.165
*** 2008-10-21 09:14:30.165
ORA-12012: error on auto execute of job 54887
ORA-06550: line ORA-06550: line 1, column 417:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 405:
PL/SQL: SQL Statement ignored
, column :
where the ACTION NAME is the name of the job.

 

Oracle定时任务:灵活可靠的任务调度工具 本文介绍了Oracle数据库的定时任务功能(DBMS_SCHEDULER),包括基本用法和高级用法。通过使用DBMS_SCHEDULER,用户可以轻松创建和管理各种类型的定时任务,满足复杂的任务调度需求。希望本文对读者理解和应用Oracle数据库的定时任务功能有所帮助。 阅读详情

相关推荐

【Oracle】Oracle JOB常用操作

【代码】Oracle job常用操作。

tttzzzqqq2018的博客 5703

Oracle 定时任务(dbms_jobs),exp & imp、expdp & impdp 数据导入导出

目录 Oracle 定时任务(dbms_jobs) Oracle 定时任务(dbms_jobs) 1、可以直接在 Oracle 数据库中创建定时任务用于执行存储函数或者存储过程,类似 windows 系统的定时任务。 2、建好后的定时任务可以在 pl/sql 工具中的左侧 DBMS_Jobs 菜单下看到,就如同查看表、视图、存储过程、序列等一样方便,显示的是任务ID(jobId)。 3、定时任务的查询、创建、禁用、停用、修改、删除 操作演示如下: select t.*,ROWID from E

蚩尤后裔-汪茂雄 1万+

面渣逆袭之Java基础篇2

Tips:所有的关键字都是小写的,在 IDE 中会以特殊颜色显示。default 这个关键字很特殊,既属于程序控制,也属于类,方法和变量修饰符,还属于访问控制。①在程序控制中,当在 switch 中匹配不到任何情况时,可以使用 default 来编写默认匹配的情况。②在类,方法和变量修饰符中,从 JDK8 开始引入了默认方法,可以使用 default 关键字来定义一个方法的默认实现。③在访问控制中,如果一个方法前没有任何修饰符,则默认会有一个修饰符 default,但是这个修饰符加上了就会报错。

m0_73804764的博客 1108

Oracle JOB相关资料介绍

Oracle JOB相关资料介绍  (一)关于Oracle JOB的用法一、设置初始化参数 job_queue_processes  sql> alter system set job_queue_processes=n;(n>0)  job_queue_processes最大值为1000  二、查看job queue 后台进程SQL> select name,descriptio

1745

手把手教你用SAM模型实现精准图像分割:从环境配置到实战应用

本文详细介绍了如何使用Meta推出的Segment Anything Model(SAM)实现精准图像分割,从环境配置到实战应用的全流程。特别针对电商场景中的商品分割需求,提供了硬件配置、模型下载、API使用及优化策略等实用指南,帮助开发者快速掌握这一强大的深度学习工具。

pepsi的博客 1062

TSMaster实战:手把手教你用C小程序发送自定义CAN报文(附完整代码)

本文详细解析了如何使用TSMaster的C小程序功能实现自定义CAN报文发送,涵盖环境配置、DBC集成、按键触发等实战技巧。通过完整代码示例和高级调试方法,帮助汽车电子工程师快速掌握TSMaster在CAN总线通信中的灵活应用,提升开发效率。

weixin_29184371的博客 574

Oracle下查看dbms_job、dbms_scheduler_job创建的任务计划的job

How to find the job name if a scheduled job fails with ORA-12012 When a scheduled job fails, the alert log shows an error message like: "O

' 忍一时风平浪静 退一步海阔天空 ' 1万+

OpenClaw 在 Docker 容器中的部署实战——零配置启动

本文介绍了OpenClaw在Docker容器中的快速部署方法,对比了本地部署与容器化部署的优势。通过官方镜像和Docker Compose两种方式,5分钟即可完成部署,并详细讲解了配置管理方案(挂载配置文件和环境变量)。文章还提供了飞书集成配置方法,以及生产环境下的日志管理、资源限制、健康检查等优化建议。最后包含常见问题排查指南,帮助开发者快速实现OpenClaw的容器化部署。

刘一说的IT专栏 904

查看oracle的查询计划任务,查看oracle创设的任务计划的job

查看oracle创建的任务计划的jobHow to find the job name if a scheduled job fails with ORA-12012When a scheduled job fails, the alert log shows an error message like:"ORA-12012 error on auto execute of job 47544"....

weixin_32522079的博客 491

Unity 实战项目 ☀️| 只用一个脚本做一个 刮刮乐 案例,一不小心刮出来一个女朋友!【学习娱乐一下】

只用一个脚本做一个刮刮乐,一不小心刮出来一个女朋友!【学习娱乐一下!】

努力前行,总会成为自己心中的那道光 23万+

【Scratch考级100图】图01-等级考试scratch绘 画正方形

一、案例介绍 小朋友们应该在数学课或者平时生活中有了解过正方形,正方形在我们生活中到处可见,那我们如果通过Scratch软件来绘制一个正方形呢,我们一起来学习一下吧,在舞台正中央绘制一个边长为200的正方形,要求: 1、围绕舞台中心绘制正多边形,均匀分布在四个象限中 2、正方形边长为200个单位,线条粗细、颜色自定 3、利用画笔绘制正方形,不能有多余的线条 二、案例演示 【Scratch案例演示】Scratch图1-画正方形 三、案例分析 当我们点击小绿旗启动程序后,舞台上会出现一个画

青少年编程学习指导 2670

oracle 怎么查任务计划,Oracle的任务计划

有时候我们为了某个需求需要定期的去执行一个任务或操作,那么这时我们会想到任务计划。没错,第一种方法我们可以利用系统的计划任务去执行某个程序。如果我们是想在数据库中 定期的去处理数据,那么我们可以用数据库的计划任务。SQLserver2005 和Oracle 都有计划任务的功能。下面是介绍Oracle9i的任务计划操作方法:先看一个简单例子 :1. 创建测试表create table a(a...

weixin_26841743的博客 777

Open3D 球旋转算法(BPA)三维建模【2026最新版】

球旋转算法,博客长期更新,本文最新更新时间为:2026年4月11日。

点云侠的博客 37万+

创建一个简单的oracle计划任务

创建一个简单的oracle计划任务 1创建一个测试表 create table students( stuno number(10), stuname NVARCHAR2(50) ); 2创建一个测试存储过程 create or replace procedure pro_insertstu is begin insert into students values(7,'部'); commit; end pro_insertstu; 3创建一个计划任务 declare jobno number

okman312的博客 4107

SAP B1中文培訓教材_SDK

公司内部培训资料,对开发工具 ,DIAPI, UIAPI,Add-ON有详细解说

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

job每小时执行一次 oracle_Oracle中定时器(Job)使用方法详解

一、dbms_job涉及到的知识点1、创建job:variablejobnonumber;dbms_job.submit(:jobno,—-job号'your_procedure;',—-执行的存储过程,';'不能省略next_date,—-下次执行时间'interval'—-每次间隔时间,interval以天为单位);–系统会自动分配一个任务号jobno。2、删除job:dbms_j...

weixin_33764463的博客 3318

霍尼韦尔SoftMaster使用说明

霍尼韦尔SoftMaster使用说明

oracle作业5分钟,Oracle调度Schedule特性(第五部分)-schedule、program、job联合

oracle 10g版本之后scheduler将job的属性分成了多个部分,program负责做什么,schedule负责啥时候做,job就简单了,一个字:干。前面几篇文章,我们分别介绍了创建管理Jobs,创建管理Programs以及创建管理Schedules,下面我们通过实例来演示,如何创建通过schedule调度program的执行的job吧。1、首先,创建一个programbegindbms...

weixin_39530960的博客 385

文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况

主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。

oracle执行存储过程历史,oracle中定期执行存储过程

--1.创建存储过程create procedure tab_auto_pro isbegininsert into tab_test values('aaaa');--//此句为要执行的sql语句,多个语句之间用";"隔开end;/--2.创建一个执行计划jobDeclarei Integer;Begindbms_job.submit(i,'tab_auto_pro;',TRUNC(LAST_D...

weixin_39684052的博客 425

oracle的定时存储过程

oracle的定时存储过程

m0_64979027的博客 1055

Oracle定时执行存储过程示例

定时执行存储过程在平时开发中经常会用到,年前的时候自己也做了一个,由于时间关系一直没能记录,现记录下来。         首先用一个完整的例子来实现定时执行存储过程。  任务目标:每小时向test表中插入一条数据  实现方案:      1.通过 oracle 中 dbms_job 完成存储过程的定时调用      2.在存储过程中完成相应的逻辑操作  实现步骤:    1.创建一个测试表  cr...

u010466666的专栏 273

Oracle定时执行存储过程

首先用一个完整的例子来实现定时执行存储过程。 任务目标:每小时向test表中插入一条数据 实现方案: 1.通过 oracle 中 dbms_job 完成存储过程的定时调用 2.在存储过程中完成相应的逻辑操作 实现步骤: 1.创建一个测试表 create table test(dTime date); 2.创建一个存储过程 create

源码好优多 2074

Oracle定时执行存储过程(转)

  定时执行存储过程在平时开发中经常会用到,年前的时候自己也做了一个,由于时间关系一直没能记录,现记录下来。       首先用一个完整的例子来实现定时执行存储过程。 任务目标:每小时向test表中插入一条数据 实现方案:     1.通过 oracle 中 dbms_job 完成存储过程的定时调用     2.在存储过程中完成相应的逻辑操作 实现步骤:   1.创建一个测试表 create t...

weixin_34218890的博客 256

oracle定时执行存储过程

注:转载 http://lafecat.iteye.com/blog/2186568 定时执行存储过程在平时开发中经常会用到,年前的时候自己也做了一个,由于时间关系一直没能记录,现记录下来。         首先用一个完整的例子来实现定时执行存储过程。  任务目标:每小时向test表中插入一条数据  实现方案:      1.通过 oracle 中 dbms_job 完成存储过程的定时调用   ...

足记的博客 636
上一篇: javascript/html中半角单/双引号转换,及Array push/join方法的使用(转)
下一篇: OCX文件在WIN7中的手动注册(转)
foolraty
博客等级 码龄19年 4粉丝 118原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值