Showing posts with label job. Show all posts
Showing posts with label job. Show all posts

Saturday, 31 October 2015

Enable Scheduler Job Execution - Oracle 11g: Cont'd

After enabling job execution on the database you might want to check the status of individual scheduler jobs. 

This can be done by querying DBA_SCHEDULER_JOBS.

SQL> select job_name, state from dba_scheduler_job where job_name = 'test_job';

JOB_NAME                    STATE
--------------------------- ---------
TEST_JOB                    DISABLED

As seen above, test_job will not run as scheduled because it us disabled. To enable test_job run;

SQL> BEGIN 
    DBMS_SCHEDULER.ENABLE('schema1.test_job'); 
END;
/

You can also can check the progress of currently running jobs by querying ALL_SCHEDULER_RUNNING_JOBS or DBA_SCHEDULER_JOBS.


Hope this helps!

Kehinde.

Thursday, 22 October 2015

Job Posting - Database Administrator

Job Title
Database Administrator

Positions Available
2

Company Profile


Education
Bachelor's degree in Computer Science or other related fields required.
An advanced degree preferred.
Relevant Certification in Database Administration preferred.

Job Requirements
Hands on Oracle database administrator with 3 years of experience installing, configuring, managing and troubleshooting oracle 9i, 10g, and 11g database software.
Requires extensive experience with Oracle RAC and multi-application environments. Requires solid understanding of server capacity planning, performance analysis and tuning, and user management. Must work closely with the server and storage engineers to design and implement high-performance and highly available environments.
Must work closely with applications in order to understand their specific requirements and guide them through the application lifecycle.
Applicant must have Architect skills – (i.e., define architecture: concepts, design, build, detailed documentation before, during and after task effort).
Applicant must be able to understand the various technology areas affected and work with those technical SMEs in building robust, stable systems
Applicant must have extensive knowledge of and experience with the span of Oracle products (i.e., Oracle Data Base, OID, Grid Control, Spatial, Partitioning, Application Server, and Data Guard). 
Applicant provides basic technical writing to describe daily operations (template provided) and security controls.
Applicant will be working in a Team environment and must have excellent communication skills, both written and verbal.
Require experience working with servers (Linux/Unix and Windows 2008).
Expert knowledge in shell scripting required.
Ability and willingness to learn new systems required.

Required Documents
Resume 
Cover Letter 

Work Location
Lagos, Nigeria

Work Schedule
Full-Time 

Posting Date
22-10-2015 


Interested applicants should submit resume to kenny_csc@yahoo.com