Can anyone please answer
You can query datadictionary views like dba|all_scheduler_job_log and/or dba|all_scheduler_job_run_details and so on for that.
Here's a list:
All available views can also be found in the documentation, example:
Suggest you explore the documentation for more details.
thanks for your suggestion but i need to know that how can i manually invalid the job /scheduler.
1 person found this helpful
I'm not sure what you mean when you say 'manually invalid'.
Do you deliberatly want a job to fail?
You could kill the session that's running the job, or have the job call a (test)procedure that runs into a deliberatly programmed error, like assigning the value 'AA' to a variable that is defined as VARCHAR2(1),
ya manually in terms of in what all kind of situations job become fail? i want to know all possible reasons of job fail.
if job failed, How can i valid that job. is there any way or script to identified
i want to know all possible reasons of job fail.
It could be anything:
- a hardware error
- a code error
- a bug
You simply cannot foresee it all.
However, when a job fails, then you can expect a trace file in one of these directories listed when you query (on 11gR2) theat will contain detailed information as to why the job failed:
select * from v$diag_info;
(usually alert log and incident dir)