An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
Answer Posted / braj123
>>First check the alert.log file for what reason the job
failed.
>>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Where would you look for errors from the database engine?
What is a correlated sub-query? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Why would you call update statistics? : sql server DBA
how can you schedule a job in database?
what is asm?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
which background process invoke at the time of upgradation tell me???