Scripts:查看数据库中的job dba_jobs.sql
来源:互联网 发布:怎么参加淘宝9.9包邮 编辑:程序博客网 时间:2024/05/19 02:27
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_jobs.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Provides summary report on all registered and scheduled jobs. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Oracle Jobs |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN job FORMAT 9999999 HEADING 'Job ID'
COLUMN username FORMAT a20 HEADING 'User'
COLUMN what FORMAT a30 HEADING 'What'
COLUMN next_date HEADING 'Next Run Date'
COLUMN interval FORMAT a30 HEADING 'Interval'
COLUMN last_date HEADING 'Last Run Date'
COLUMN failures HEADING 'Failures'
COLUMN broken FORMAT a7 HEADING 'Broken?'
SELECT
job
, log_user username
, what
, TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date
, interval
, TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date
, failures
, broken
FROM
dba_jobs;
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : dba_jobs.sql |
-- | CLASS : Database Administration |
-- | PURPOSE : Provides summary report on all registered and scheduled jobs. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET TERMOUT OFF;
COLUMN current_instance NEW_VALUE current_instance NOPRINT;
SELECT rpad(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON;
PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report : Oracle Jobs |
PROMPT | Instance : ¤t_instance |
PROMPT +------------------------------------------------------------------------+
SET ECHO OFF
SET FEEDBACK 6
SET HEADING ON
SET LINESIZE 180
SET PAGESIZE 50000
SET TERMOUT ON
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET VERIFY OFF
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
COLUMN job FORMAT 9999999 HEADING 'Job ID'
COLUMN username FORMAT a20 HEADING 'User'
COLUMN what FORMAT a30 HEADING 'What'
COLUMN next_date HEADING 'Next Run Date'
COLUMN interval FORMAT a30 HEADING 'Interval'
COLUMN last_date HEADING 'Last Run Date'
COLUMN failures HEADING 'Failures'
COLUMN broken FORMAT a7 HEADING 'Broken?'
SELECT
job
, log_user username
, what
, TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date
, interval
, TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date
, failures
, broken
FROM
dba_jobs;
0 0
- Scripts:查看数据库中的job dba_jobs.sql
- Scripts:查看数据库中的报错dba_errors.sql
- Scripts:查看数据库里面建的directories dba_directories.sql
- ORACLE DBA_JOBS中的FAILURES
- Scripts:显示数据库中的控制文件dba_controlfiles.sql
- Scripts:查询数据库中的无效对象dba_invalid_objects.sql
- Scripts:报告数据库中的top segment的脚本dba_top_segments.sql
- 关于数据库中的Job
- Scripts:查询数据库对象汇总dba_object_summary.sql
- Scripts:数据库升级诊断脚本dbupgdiag.sql
- Scripts:查看回滚的SQL的脚本 huigun.sql
- 利用SQL查看JOB执行的状况
- 查看 SQL 中JOB 的运行状态
- 查看 SQL 中JOB 的运行状态
- Scripts:查看AWR中热点物理读awrtoprdrpt.sql
- Scripts:查看未提交的事务的脚本CurrentActivity.sql
- Scripts:报告数据库中所有数据文件使用情况dba_files_all.sql
- Scripts:报告数据库中段使用情况的汇总dba_segment_summary.sql
- Scripts:报告无效对象汇总dba_invalid_objects_summary.sql
- Android Gson解析
- Linux curl使用简单介绍
- unity网络通信3--同步物体
- bootstrap-datetimepicker:基于twitter bootstrap的日期/时间选择控件
- Scripts:查看数据库中的job dba_jobs.sql
- Python BeautifulSoup
- 2014苹果个人IDP申请流程
- Android 布局笔记
- 《APUE》:信号处理
- Scripts:重新编译失效对象的脚本(生产环境慎用)dba_recompile_invalid_objects.sql
- 使用ObjectMapper把json转换为实体-时间转换问题
- python 登录人人网
- 【备份】【简单值转换器】流量值按K/M/G/T/P显示