Question:
Hello, could anybody tell me where can i find the job number of those jobs defined in dba_scheduler_jobs? either whose owner is EXFSYS or a created owner.
I see some errors in alert log but i cann't go to the job number specified because i cann't find them, this jobs have been defined by means of the scheduler.
Thanks in advance.
Answer:
Hi,
A job is primarily identified by its name and owner. If you see an error in the alert/log it should point to a job slave trace file. In the job slave trace file you will see the job name. Then you can do a select from dba_scheduler jobs filtering by job_name and owner.
The job id for a scheduler job is intended to be for internal use only. If you absolutely need to find the job name for a job id you can do (as SYS)
SELECT o.name object_name, u.name object_owner FROM
obj$ o, user$ u WHERE
o.obj# = JOB_ID and o.owner# = u.user#;
or to get all jobs owned by a particular user
SELECT o.name object_name, u.name object_owner, o.obj# job_id FROM
obj$ o, user$ u WHERE
o.owner# = u.user# and u.name='USERNAME' and o.type#=66;
But neither of these should even be necesary.
Hope this helps,
Ravi.
分享到:
相关推荐
Software_Defined_Radio_using_MATLAB_Simulink_and_the_RTL-SDR.pdf,已去除文件保护,可编辑
Software_Defined_Radio_using_MATLAB_Simulink_and_the_RTL-SDR_book.zip
Software_Defined_Radio_using_MATLAB_Simulink_and_the_RTL-SDR第三章中文翻译版
Software_Defined_Radio_using_MATLAB_Simulink_and_the_RTL-SDR配套工程文件(1.5GB)
软件无线电书籍,使用matlab代码,基于RTL-SDR设备,非常好!!!!!!!!
C++经典错误之already defined in *****.obj解决方法
Lock-in amplifiers were invented in the 1930’s [1, 2, 3] and commercialized [4] in the mid 20th century as electrical instruments capable of extracting signal amplitudes and phases in extremely ...
软件定义边界(SDP)实践探索_The_Journey_of_Building_Software-Defined_Perimeter_(SDP)_Product_in_China_陈 自动化 法律法规 安全对抗 网络与基础架构安全 信息安全研究
34. Where can I find an overview of SAP HANA features introduced with certain patch levels? 35. Where can I find information about available, used and deprecated features? 36. Does SAP HANA provide a ...
CMSIS目前支持三大主流的工具链,即ARM RealView (armcc), IAR... #if defined ( __CC_ARM ) #define __ASM __asm /*!*/ #define __INLINE __inline /*!*/ #elif defined ( __ICCARM__ ) #define __ASM __asm /*!*/
mini_scheduler MiniScheduler将定期作业添加到。 安装 将此行添加到您的应用程序的Gemfile中: gem 'mini_scheduler' 然后执行: $ bundle 或将其自己安装为: $ gem install mini_scheduler ... && defined?(Rai
彻底解决 __vd_version_info__ is not defined 等出错问题,完美反编译出微信小程序, 已测试。直接下载后按照 qwerty472123/wxappUnpacker 方式使用。原qwerty472123/wxappUnpacker的版本已过时。
The number of levels in an index will vary depending on the number of rows in the table and the size of the key column or columns for the index. If you create an index using a large key, fewer ...
numbers, and they have an equally complex and intriguing history, from Euclid's famous proof that the square root of 2 is irrational to Roger Apéry's proof of the irrationality of a number called ...
软件无线电,Simulink 文档类型:电子书 页数:674 2015年新书
_DllMain@12 already defined in
Abstract— With the advent of 5G, technologies such as Software-Defined Networks (SDNs) and Network Function Virtualization (NFV) have been developed to facilitate simple programmable control of ...
Quartz is a full-featured, open source job scheduling service that can be integrated with, or used along side virtually any Java EE or Java SE application - from the smallest stand-alone application ...
the ARM ADS, so you will need to re-write those sections of existing code Original ARM Syntax | fasmarm Syntax ----------------------+---------------------- cpsie a | cpsie iflags_a | ...