all_scheduler_job_run_details Viewing Job History Monitoring Jobs

all_scheduler_job_run_details Viewing Job History Monitoring Jobs

We encourage you to read our updated PRIVACY POLICY and COOKIE POLICY .

×

Top

Explore

Toolbox Logo Tech
Sign In

  • Contribute
  • Explore

    • Tech Home
    • Big Data
      • Data Science
      • Edge Computing
      • Hadoop
      • IBM Cognos
      • OLAP
      • Predictive Analytics
      • Visualization
    • Cloud
      • AWS
      • Azure
      • Cloud Architecture
      • Cloud Security
      • Cloud Storage
      • Google Cloud
      • Hybrid Cloud
    • Collaboration
      • Call Center
      • Chatbots
      • Comm Tech
      • Email
      • Instant Messaging
      • IP PBX
      • SIP Trunking
      • Slack
      • Unified Communications
      • Video
      • VoIP
    • DevOps
      • Agile
      • Continuous Delivery
      • Docker
      • GitHub
      • IDEs
      • Help Desk
      • Jenkins
      • Kubernetes
      • Project Management
      • QA
      • Software Development
      • Splunk
      • Test Automation
      • Web Hosting
    • Infrastructure
      • Data Center
      • Disaster Planning
      • Hardware
      • Networking
      • Storage
      • Virtualization
    • Innovation
      • Artificial Intelligence
      • Blockchain
      • Cryptocurrency
      • FinTech
      • IBM Watson
      • IoT
      • Machine Learning
      • Quantum Computing
      • Virtual Reality
    • Mobility
      • BYOD
      • EMM
      • MDM
      • Mobile Computing
      • Mobile Payments
      • Mobile Tech
      • Smart Devices
    • Operating Systems
      • Android
      • GNOME
      • IBM AIX
      • iOS
      • Linux
      • Mac OS X
      • Office 365
      • OpenBSD
      • Ubuntu
      • Unix
      • Windows 10
      • Windows 7
      • Windows Vista
      • Windows XP
    • Programming
      • .NET
      • Ajax
      • C#
      • C++
      • CSS
      • HTML
      • Java
      • JavaScript
      • jQuery
      • MySQL
      • Objective-C
      • PHP
      • Python
      • Ruby
      • Shell Script
      • SQL
      • Visual Basic
    • Security
      • Antivirus
      • Cybersecurity
      • Encryption
      • Endpoint Security
      • Fraud Detection
      • Identity & Access Management
      • Intrusion Prevention
      • Malware
      • Ransomware
      • SIEM
      • Vulnerability Assessment
    • Strategy
      • Digital Transformation
      • Governance
      • Leadership
      • Outsourcing
      • Spending
      • Staffing
      • Sustainability
      • Training
    Enterprise Software
    • Applications
      • Business Process Management
      • Content Management Systems
      • Customer Relationship Management
      • Enterprise Application Integration
      • Enterprise Resource Planning
      • Product Lifecycle Management
      • Supply Chain Management
    • Infor
      • Infor CRM
      • Infor ERP
      • Infor HCM
      • Infor SCM
    • Oracle
      • Oracle Applications
      • Oracle Cloud
      • Oracle CRM
      • Oracle Database
      • Oracle E-Business Suite
      • Oracle Forms
      • Oracle Fusion Middleware
      • Oracle Hyperion
      • Oracle SQL
    • PeopleSoft
      • PeopleCode
      • PeopleSoft CRM
      • PeopleSoft EPM
      • PeopleSoft Finance
      • PeopleSoft Fluid
      • PeopleSoft HR
      • PeopleSoft SCM
      • PeopleTools
    • SAP
      • SAP ABAP
      • SAP Accounting
      • SAP Ariba
      • SAP Basis
      • SAP BAPI
      • SAP BW
      • SAP Business One
      • SAP FICO
      • SAP Netweaver
      • SAP Leonardo
      • SAP Logistics
      • SAP MM
      • SAP S/4HANA
      • SAP Solution Manager
    • Siebel
      • Siebel CRM
      • Siebel CX
      • Siebel Development
      • Siebel EIM
      • Siebel Marketing
      • Siebel PRM
      • Siebel Sales
    • Resources
      • Blogs
      • How To’s
      • News
      • Q&A
      • Tags
      • Videos
      • Webcasts
      • White Papers
    • Industries
      • Education
      • Government
      • Healthcare
      • Hospitality
      • Manufacturing
      • Retail
    • Break Room
      • Books
      • Gaming
      • Personal Tech
      • Road Warrior

    • Tech Home
    • Big Data
      • Data Science
      • Edge Computing
      • Hadoop
      • IBM Cognos
      • OLAP
      • Predictive Analytics
      • Visualization
    • Cloud
      • AWS
      • Azure
      • Cloud Architecture
      • Cloud Security
      • Cloud Storage
      • Google Cloud
      • Hybrid Cloud
    • Collaboration
      • Call Center
      • Chatbots
      • Comm Tech
      • Email
      • Instant Messaging
      • IP PBX
      • SIP Trunking
      • Slack
      • Unified Communications
      • Video
      • VoIP
    • DevOps
      • Agile
      • Continuous Delivery
      • Docker
      • GitHub
      • IDEs
      • Help Desk
      • Jenkins
      • Kubernetes
      • Project Management
      • QA
      • Software Development
      • Splunk
      • Test Automation
      • Web Hosting
    • Infrastructure
      • Data Center
      • Disaster Planning
      • Hardware
      • Networking
      • Storage
      • Virtualization
    • Innovation
      • Artificial Intelligence
      • Blockchain
      • Cryptocurrency
      • FinTech
      • IBM Watson
      • IoT
      • Machine Learning
      • Quantum Computing
      • Virtual Reality
    • Mobility
      • BYOD
      • EMM
      • MDM
      • Mobile Computing
      • Mobile Payments
      • Mobile Tech
      • Smart Devices
    • Operating Systems
      • Android
      • GNOME
      • IBM AIX
      • iOS
      • Linux
      • Mac OS X
      • Office 365
      • OpenBSD
      • Ubuntu
      • Unix
      • Windows 10
      • Windows 7
      • Windows Vista
      • Windows XP
    • Programming
      • .NET
      • Ajax
      • C#
      • C++
      • CSS
      • HTML
      • Java
      • JavaScript
      • jQuery
      • MySQL
      • Objective-C
      • PHP
      • Python
      • Ruby
      • Shell Script
      • SQL
      • Visual Basic
    • Security
      • Antivirus
      • Cybersecurity
      • Encryption
      • Endpoint Security
      • Fraud Detection
      • Identity & Access Management
      • Intrusion Prevention
      • Malware
      • Ransomware
      • SIEM
      • Vulnerability Assessment
    • Strategy
      • Digital Transformation
      • Governance
      • Leadership
      • Outsourcing
      • Spending
      • Staffing
      • Sustainability
      • Training
    Enterprise Software
    • Applications
      • Business Process Management
      • Content Management Systems
      • Customer Relationship Management
      • Enterprise Application Integration
      • Enterprise Resource Planning
      • Product Lifecycle Management
      • Supply Chain Management
    • Infor
      • Infor CRM
      • Infor ERP
      • Infor HCM
      • Infor SCM
    • Oracle
      • Oracle Applications
      • Oracle Cloud
      • Oracle CRM
      • Oracle Database
      • Oracle E-Business Suite
      • Oracle Forms
      • Oracle Fusion Middleware
      • Oracle Hyperion
      • Oracle SQL
    • PeopleSoft
      • PeopleCode
      • PeopleSoft CRM
      • PeopleSoft EPM
      • PeopleSoft Finance
      • PeopleSoft Fluid
      • PeopleSoft HR
      • PeopleSoft SCM
      • PeopleTools
    • SAP
      • SAP ABAP
      • SAP Accounting
      • SAP Ariba
      • SAP Basis
      • SAP BAPI
      • SAP BW
      • SAP Business One
      • SAP FICO
      • SAP Netweaver
      • SAP Leonardo
      • SAP Logistics
      • SAP MM
      • SAP S/4HANA
      • SAP Solution Manager
    • Siebel
      • Siebel CRM
      • Siebel CX
      • Siebel Development
      • Siebel EIM
      • Siebel Marketing
      • Siebel PRM
      • Siebel Sales
    • Resources
      • Blogs
      • How To’s
      • News
      • Q&A
      • Tags
      • Videos
      • Webcasts
      • White Papers
    • Industries
      • Education
      • Government
      • Healthcare
      • Hospitality
      • Manufacturing
      • Retail
    • Break Room
      • Books
      • Gaming
      • Personal Tech
      • Road Warrior

Sites:
  • Tech
  • HR
  • Finance
  • Marketing

  • twitter
  • linkedin
  • facebook

Close

Toolbox Logo Tech
Toolbox Logo

  • Contribute
  • Explore

    • Tech Home
    • Big Data
      • Data Science
      • Edge Computing
      • Hadoop
      • IBM Cognos
      • OLAP
      • Predictive Analytics
      • Visualization
    • Cloud
      • AWS
      • Azure
      • Cloud Architecture
      • Cloud Security
      • Cloud Storage
      • Google Cloud
      • Hybrid Cloud
    • Collaboration
      • Call Center
      • Chatbots
      • Comm Tech
      • Email
      • Instant Messaging
      • IP PBX
      • SIP Trunking
      • Slack
      • Unified Communications
      • Video
      • VoIP
    • DevOps
      • Agile
      • Continuous Delivery
      • Docker
      • GitHub
      • IDEs
      • Help Desk
      • Jenkins
      • Kubernetes
      • Project Management
      • QA
      • Software Development
      • Splunk
      • Test Automation
      • Web Hosting
    • Infrastructure
      • Data Center
      • Disaster Planning
      • Hardware
      • Networking
      • Storage
      • Virtualization
    • Innovation
      • Artificial Intelligence
      • Blockchain
      • Cryptocurrency
      • FinTech
      • IBM Watson
      • IoT
      • Machine Learning
      • Quantum Computing
      • Virtual Reality
    • Mobility
      • BYOD
      • EMM
      • MDM
      • Mobile Computing
      • Mobile Payments
      • Mobile Tech
      • Smart Devices
    • Operating Systems
      • Android
      • GNOME
      • IBM AIX
      • iOS
      • Linux
      • Mac OS X
      • Office 365
      • OpenBSD
      • Ubuntu
      • Unix
      • Windows 10
      • Windows 7
      • Windows Vista
      • Windows XP
    • Programming
      • .NET
      • Ajax
      • C#
      • C++
      • CSS
      • HTML
      • Java
      • JavaScript
      • jQuery
      • MySQL
      • Objective-C
      • PHP
      • Python
      • Ruby
      • Shell Script
      • SQL
      • Visual Basic
    • Security
      • Antivirus
      • Cybersecurity
      • Encryption
      • Endpoint Security
      • Fraud Detection
      • Identity & Access Management
      • Intrusion Prevention
      • Malware
      • Ransomware
      • SIEM
      • Vulnerability Assessment
    • Strategy
      • Digital Transformation
      • Governance
      • Leadership
      • Outsourcing
      • Spending
      • Staffing
      • Sustainability
      • Training
    Enterprise Software
    • Applications
      • Business Process Management
      • Content Management Systems
      • Customer Relationship Management
      • Enterprise Application Integration
      • Enterprise Resource Planning
      • Product Lifecycle Management
      • Supply Chain Management
    • Infor
      • Infor CRM
      • Infor ERP
      • Infor HCM
      • Infor SCM
    • Oracle
      • Oracle Applications
      • Oracle Cloud
      • Oracle CRM
      • Oracle Database
      • Oracle E-Business Suite
      • Oracle Forms
      • Oracle Fusion Middleware
      • Oracle Hyperion
      • Oracle SQL
    • PeopleSoft
      • PeopleCode
      • PeopleSoft CRM
      • PeopleSoft EPM
      • PeopleSoft Finance
      • PeopleSoft Fluid
      • PeopleSoft HR
      • PeopleSoft SCM
      • PeopleTools
    • SAP
      • SAP ABAP
      • SAP Accounting
      • SAP Ariba
      • SAP Basis
      • SAP BAPI
      • SAP BW
      • SAP Business One
      • SAP FICO
      • SAP Netweaver
      • SAP Leonardo
      • SAP Logistics
      • SAP MM
      • SAP S/4HANA
      • SAP Solution Manager
    • Siebel
      • Siebel CRM
      • Siebel CX
      • Siebel Development
      • Siebel EIM
      • Siebel Marketing
      • Siebel PRM
      • Siebel Sales
    • Resources
      • Blogs
      • How To’s
      • News
      • Q&A
      • Tags
      • Videos
      • Webcasts
      • White Papers
    • Industries
      • Education
      • Government
      • Healthcare
      • Hospitality
      • Manufacturing
      • Retail
    • Break Room
      • Books
      • Gaming
      • Personal Tech
      • Road Warrior

    • Tech Home
    • Big Data
      • Data Science
      • Edge Computing
      • Hadoop
      • IBM Cognos
      • OLAP
      • Predictive Analytics
      • Visualization
    • Cloud
      • AWS
      • Azure
      • Cloud Architecture
      • Cloud Security
      • Cloud Storage
      • Google Cloud
      • Hybrid Cloud
    • Collaboration
      • Call Center
      • Chatbots
      • Comm Tech
      • Email
      • Instant Messaging
      • IP PBX
      • SIP Trunking
      • Slack
      • Unified Communications
      • Video
      • VoIP
    • DevOps
      • Agile
      • Continuous Delivery
      • Docker
      • GitHub
      • IDEs
      • Help Desk
      • Jenkins
      • Kubernetes
      • Project Management
      • QA
      • Software Development
      • Splunk
      • Test Automation
      • Web Hosting
    • Infrastructure
      • Data Center
      • Disaster Planning
      • Hardware
      • Networking
      • Storage
      • Virtualization
    • Innovation
      • Artificial Intelligence
      • Blockchain
      • Cryptocurrency
      • FinTech
      • IBM Watson
      • IoT
      • Machine Learning
      • Quantum Computing
      • Virtual Reality
    • Mobility
      • BYOD
      • EMM
      • MDM
      • Mobile Computing
      • Mobile Payments
      • Mobile Tech
      • Smart Devices
    • Operating Systems
      • Android
      • GNOME
      • IBM AIX
      • iOS
      • Linux
      • Mac OS X
      • Office 365
      • OpenBSD
      • Ubuntu
      • Unix
      • Windows 10
      • Windows 7
      • Windows Vista
      • Windows XP
    • Programming
      • .NET
      • Ajax
      • C#
      • C++
      • CSS
      • HTML
      • Java
      • JavaScript
      • jQuery
      • MySQL
      • Objective-C
      • PHP
      • Python
      • Ruby
      • Shell Script
      • SQL
      • Visual Basic
    • Security
      • Antivirus
      • Cybersecurity
      • Encryption
      • Endpoint Security
      • Fraud Detection
      • Identity & Access Management
      • Intrusion Prevention
      • Malware
      • Ransomware
      • SIEM
      • Vulnerability Assessment
    • Strategy
      • Digital Transformation
      • Governance
      • Leadership
      • Outsourcing
      • Spending
      • Staffing
      • Sustainability
      • Training
    Enterprise Software
    • Applications
      • Business Process Management
      • Content Management Systems
      • Customer Relationship Management
      • Enterprise Application Integration
      • Enterprise Resource Planning
      • Product Lifecycle Management
      • Supply Chain Management
    • Infor
      • Infor CRM
      • Infor ERP
      • Infor HCM
      • Infor SCM
    • Oracle
      • Oracle Applications
      • Oracle Cloud
      • Oracle CRM
      • Oracle Database
      • Oracle E-Business Suite
      • Oracle Forms
      • Oracle Fusion Middleware
      • Oracle Hyperion
      • Oracle SQL
    • PeopleSoft
      • PeopleCode
      • PeopleSoft CRM
      • PeopleSoft EPM
      • PeopleSoft Finance
      • PeopleSoft Fluid
      • PeopleSoft HR
      • PeopleSoft SCM
      • PeopleTools
    • SAP
      • SAP ABAP
      • SAP Accounting
      • SAP Ariba
      • SAP Basis
      • SAP BAPI
      • SAP BW
      • SAP Business One
      • SAP FICO
      • SAP Netweaver
      • SAP Leonardo
      • SAP Logistics
      • SAP MM
      • SAP S/4HANA
      • SAP Solution Manager
    • Siebel
      • Siebel CRM
      • Siebel CX
      • Siebel Development
      • Siebel EIM
      • Siebel Marketing
      • Siebel PRM
      • Siebel Sales
    • Resources
      • Blogs
      • How To’s
      • News
      • Q&A
      • Tags
      • Videos
      • Webcasts
      • White Papers
    • Industries
      • Education
      • Government
      • Healthcare
      • Hospitality
      • Manufacturing
      • Retail
    • Break Room
      • Books
      • Gaming
      • Personal Tech
      • Road Warrior

Search

Sign In
Close
  • Forgot Password?
  • Don’t have an account? Sign up

Oracle

Purge log history job using DBMS_SCHEDULER.PURGE_LOG automatically

3

Answers

0

Favorites

Bookmark

0

Follow

Share

“Dear, How to purge log history job using DBMS_SCHEDULER.PURGE_LOG automatically ? Thanks for support. Regards, Defry”
f_1706532
f_1706532

Defry Afrian

DBA & Sysadmin

0Follower
0Following


Follow

Related Tags:
  • Oracle

    Some name

    98606
    Followers

    + Follow

3 Answers
Answer this question

Sign In to Post a Comment
Sign In

Make Scheduler job on sys user… to call DBMS_SCHEDULER.PURGE_LOG

Surachart Opun

http://surachartopun.com

Answered

Sorry! Something went wrong on our end. Please try again later.

Hi Surachat,

I was try as your mention but not working.

This is for detail :

On schema abc, I have job like this :

BEGIN

SYS.DBMS_SCHEDULER.CREATE_JOB

(

job_name => ‘ABC.COMP_INVALID_MV’

,start_date => TO_TIMESTAMP_TZ(‘2010/08/25 10:40:50.749527 +07:00′,’yyyy/mm/dd hh24:mi:ss.ff tzr’)

,repeat_interval => ‘FREQ=MINUTELY;INTERVAL=5’

,end_date => NULL

,job_class => ‘DEFAULT_JOB_CLASS’

,job_type => ‘STORED_PROCEDURE’

,job_action => ‘ABC.COMPILE_INVALID_MV’

,comments => ‘Runs compile invalid object procedures every five minutes’

);

END;

I want purge log on job ABC.COMPILE_INVALID_MV using ;

CREATE OR REPLACE PROCEDURE PURGE_COMP_INVALID_MV IS

BEGIN

EXECUTE IMMEDIATE ‘DBMS_SCHEDULER.PURGE_LOG (0, ”JOB_AND_WINDOW_LOG”, ”PURGE_LOG_COMP_INVALID_MV”)’;

END;

Then I’m create job on sys user like this :

BEGIN

SYS.DBMS_SCHEDULER.CREATE_JOB

(

job_name => ‘PURGE_LOG_COMP_INVALID_MV’

,start_date => TO_TIMESTAMP_TZ(‘2010/12/01 12:00:00.749527 +07:00′,’yyyy/mm/dd hh24:mi:ss.ff tzr’)

,repeat_interval => ‘FREQ=MINUTELY;INTERVAL=5’

,end_date => NULL

,job_class => ‘DEFAULT_JOB_CLASS’

,job_type => ‘STORED_PROCEDURE’

,job_action => ‘ABC.PURGE_COMP_INVALID_MV’

,comments => ‘Purge Log History’

);

END;

Please give me advice.

Regards,

Defry

Answered

Sorry! Something went wrong on our end. Please try again later.

I use :

BEGIN

sys.dbms_scheduler.create_job(

job_name => ‘”SYS”.”JB_CLEAN_01″‘,

job_type => ‘PLSQL_BLOCK’,

job_action => ‘begin

DBMS_SCHEDULER.PURGE_LOG(7);

end;’,

repeat_interval => ‘FREQ=DAILY;BYHOUR=6;BYMINUTE=0;BYSECOND=0’,

start_date => to_timestamp_tz(‘2008-01-15 Asia/Bangkok’, ‘YYYY-MM-DD TZR’),

job_class => ‘”DEFAULT_JOB_CLASS”‘,

auto_drop => FALSE,

enabled => FALSE);

sys.dbms_scheduler.set_attribute( name => ‘”SYS”.”JB_CLEAN_01″‘, attribute => ‘job_weight’, value => 1);

sys.dbms_scheduler.set_attribute( name => ‘”SYS”.”JB_CLEAN_01″‘, attribute => ‘instance_stickiness’, value => FALSE);

sys.dbms_scheduler.enable( ‘”SYS”.”JB_CLEAN_01″‘ );

END;

/

and It’s OK…

Answered

Sorry! Something went wrong on our end. Please try again later.


Sorry! Something went wrong on our end. Please try again later.

Related
  • GridGain Announces Availability of In-Memory Computing Platform in Oracle Cloud Marketplace

  • After Submitting Expense Report Export in AP R12, No Invoice Was Created

  • Expense Report Export Did Not Create Invoice

  • Value Is Not Showing in CALLING PARAMETER FOMR TO GRAPHICS Report 6i

  • How to Generate Excel File from Oracle Reports Apps ERP?

  • How to Automatically Update Oracle MRP Work Orders Due Date?

  • Oracle Stored Procedures and the XREF Search

  • Pick Slip Report Output Sorting Issue

An Oracle Spin by Alex Lima

Sharing My Database Experience

Alex Lima

How to find jobs currently running or history about the jobs?

In 10g one can find the jobs that are currently running by querying the following view

SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;

Also one can use the following view to find the history details of job that has run.

SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;

To find the jobs that haven’t succeeded
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status ‘SUCCEEDED’;

Advertisements

Share this:

  • Click to email this to a friend (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Google+ (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)

2 comments

  1. what is the functionality of sql loader ? how it internally works

    Reply
  2. Reblogged this on jmarquez1974 and commented:
    How to find jobs currently running or history about the jobs?
    Alex Lima / November 26, 2008
    In 10g one can find the jobs that are currently running by querying the following view

    SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;

    Also one can use the following view to find the history details of job that has run.

    SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;

    To find the jobs that haven’t succeeded
    SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status ‘SUCCEEDED’;

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed .


Categories

  • Backup & Recovery (49)
    • Archivelog (3)
    • Flashback (5)
    • RMAN (36)
  • Dataguard (3)
  • Datatypes (6)
    • Date (2)
    • LOB (2)
  • Export (6)
    • exp (2)
  • General DBA (245)
    • 18c (1)
    • AIX (1)
    • Control file (3)
    • Dataguard (3)
    • Internal (4)
    • Lock (3)
    • Log Miner (1)
    • Monitor (1)
    • partition (1)
    • role (3)
    • Scheduler (9)
  • Globalization (6)
  • GoldenGate (7)
  • install (2)
  • Listener (4)
  • mac (1)
  • MySQL (5)
    • JDBC (5)
  • NetApp for Oracle (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • OS (2)
    • Linux (1)
  • Parameters (8)
    • Initialization (4)
  • performance (1)
  • PL/SQL (4)
  • Primavera (3)
  • Project Management (3)
  • Scripts (25)
  • Security (7)
    • Password (3)
  • sga (4)
    • Shared Pool (3)
  • SQL – DDL (4)
  • SQL Server (72)
    • Backup (4)
    • Built-in stored procedures (1)
    • Connections (1)
    • Cursor (3)
    • Database (12)
    • Grant (5)
    • Jobs (4)
    • osql (1)
    • Profiler (1)
    • Table (3)
    • Tuning (6)
  • SQL*Plus (17)
    • SQLcl (1)
  • startup (4)
  • tablespace (2)
  • trace (33)
    • Auditing (2)
    • oradebug (9)
  • Transaction (5)
  • Tuning (42)
    • AWR (10)
    • Statistics (14)
    • Statspack (3)
  • Undo (1)
  • Unix (33)
    • Shell (15)
  • vi (5)
  • windows (11)
    • Batch (1)
    • Power Shell (2)

Visit us at:

Follow Us

  • Twitter

  • LinkedIn

Twitter Updates

  • RT @ BIASCORP : On the twelfth day of Christmas the BIAS Team hosted an annual ping pong tourney and had an undefeated cricket team.

    Stay tu… 14 hours ago

  • Am i spoiled? My Internet speed is 320Mbps. How FAST is your Internet? fast.com/en/share/320Mb… 18 hours ago
  • As Court Orders Airline To Surrender 20% Of Fleet, United Watches From Afar liveandletsfly.boardingarea.com/2018/12/10/avi… 3 days ago
  • went for a 1.5 kilometer Swim. strava.com/activities/200… #strava 1 week ago
  • RT @ CdnPress_Sports : Canada earns spot in 2019 FIBA World Cup with rout of Brazil
    bit.ly/2zFii2l 1 week ago

Follow @aoflima

Recent Posts

  • Read Only Partitions 12.2
  • 12.2 Data Guard Password Sync
  • 18c Installed on Premises
  • What’s up with the new Oracle releases names
  • Docker Installation of Oracle Database 12c on Mac

Top Posts

  • How to enable/disable a scheduled job?

  • How to lock/unlock statistics on a table?

  • How to see current utilization of processes/sessions and max utilization?

  • How to find jobs currently running or history about the jobs?

  • How to stop a job scheduled in DBMS_SCHEDULER?

  • How to grant SELECT access to v$session to other users?

  • How to find the NLS_LANG to set for a database?

  • ALTER DATABASE BEGIN/END BACKUP

  • How to find row that has non-numeric value in a character column?

  • How to delete archive logs already archived to backup device?

Advertisements

%d bloggers like this:
















































Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SCHEDULER_JOB_RUN_DETAILS

ALL_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs accessible to the current user.

Related Views

ColumnDatatypeNULLDescription
LOG_IDNUMBER Unique identifier of the log entry
LOG_DATETIMESTAMP(6) WITH TIME ZONE Date of the log entry
OWNERVARCHAR2(30) Owner of the Scheduler job
JOB_NAMEVARCHAR2(30) Name of the Scheduler job
STATUSVARCHAR2(30) Status of the job run
ERROR#NUMBER Error number in the case of an error
REQ_START_DATETIMESTAMP(6) WITH TIME ZONE Requested start date of the job run
ACTUAL_START_DATETIMESTAMP(6) WITH TIME ZONE Actual date on which the job was run
RUN_DURATIONINTERVAL DAY(3) TO SECOND(0) Duration of the job run
INSTANCE_IDNUMBER Identifier of the instance on which the job was run
SESSION_IDVARCHAR2(30) Session identifier of the job run
SLAVE_PIDVARCHAR2(30) Process identifier of the slave on which the job was run
CPU_USEDNUMBER Amount of CPU used for the job run
ADDITIONAL_INFOVARCHAR2(4000) Additional information on the job run, if applicable

See Also:

  • “DBA_SCHEDULER_JOB_RUN_DETAILS”

  • “USER_SCHEDULER_JOB_RUN_DETAILS”


Go to previous page
Previous
Go to next page
Next
Oracle
Copyright © 2002, 2003, Oracle Corporation
All Rights Reserved.
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback