Interested to Buy Any Domain ? << Click Here >> for more details...
An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
- 1 Answers
- 5171 Views
- I also Faced
- E-Mail Answers
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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you implement fine-grained auditing?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is the role of dip user in our database?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explain about your sql server dba experience? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the different ways you can create databases in sql server? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the recovery models for a database? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can a session indicate its interest in receiving alerts?
What are the commands used in dcl? : sql server DBA
