Friday, December 15, 2017

Oracle schedule job status and log

Oracle schedule job status and log


select * from ALL_SCHEDULER_JOB_RUN_DETAILS order by log_date desc;

select * from ALL_SCHEDULER_JOBS

SELECT VALUE
FROM V$PARAMETER
WHERE NAME = '';

SELECT *
FROM DBA_SCHEDULER_JOB_RUN_DETAILS where job_name=''
ORDER BY LOG_DATE DESC;



No comments:

Post a Comment

AWS how to delete VPC when it has error with Network interface , Gateway decencies

   how to delete VPC when it has error with Network interface , Gateway decencies  in AWS 1. Check if it is running on EC2 instance then Sto...