Showing posts with label job schedule. Show all posts
Showing posts with label job schedule. Show all posts
Thursday, February 14, 2013

Purge Queue

›
BEGIN   DBMS_SCHEDULER.create_job (     job_name        => 'purge_boqueue',     job_type        => 'PLSQL_BLOCK', ...

Job Analyze Temp tables

›
CREATE OR REPLACE PROCEDURE Analyzetemp AS BEGIN  FOR CUR_REC IN (SELECT DISTINCT OWNER,TABLE_NAME                   FROM   DBA_TABLES w...

Analyze Full

›
CREATE OR REPLACE PROCEDURE AnalyzeFull AS BEGIN  FOR CUR_REC IN (SELECT DISTINCT OWNER,TABLE_NAME                   FROM   DBA_TABLES) ...

User Creation With job

›
host mkdir c:\yep1314 spool c:\yep1314\yep1314.log --------------User Creation CREATE USER LDBO PROFILE "DEFAULT" IDENTIFIE...

job rebuild index 11G

›
create or replace procedure sp_rebuildindex as   vOwner   dba_indexes.owner%TYPE;            /* Index Owner            */   vIdxName dba_...

Temporary Tablespace Cleanup 11g

›
alter tablespace temporary shrink space keep 1G; exec dbms_scheduler.drop_job('tempshrink');  begin dbms_scheduler.create_job ...

job OS audit files maintaince

›
For Oracle on unix .aud files are created whether you have auditing enabled or not.  They record sys operations.  If you've got a lot o...
Tuesday, July 3, 2012

Analyze Stale Job

›
BEGIN   DBMS_SCHEDULER.create_job (     job_name        => 'analyze_stale',     job_type        => 'PLSQL_BLOCK', ...
Wednesday, June 6, 2012

Schedule Job for specific time interval

›
BEGIN   DBMS_SCHEDULER.create_job (     job_name        => 'Test',     job_type        => 'PLSQL_BLOCK',     job_...
Monday, April 23, 2012

Job Scheduler for RMAN backup

›
1) RMAN TARGET SYS/.....@KSH1213SRV CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE CONTROLFILE ...
Friday, April 20, 2012

Oracle Job Scheduler for Old Analyze Method / Full Analyze

›
create or replace procedure AnalyzeFull as BEGIN  FOR cur_rec IN (SELECT distinct table_name                   FROM   dba_tables) LOOP  ...

Oracle Job Scheduler for Rename Export dump file / OS files

›
UTL_FILE.FRENAME ( location  IN VARCHAR2,    filename  IN VARCHAR2,    dest_dir  IN VARCHAR2,    dest_file IN VARCHAR2,    overwrite IN ...

Oracle Job Scheduler for Remove export files / OS files

›
select * from dba_directories; exec utl_file.fremove('MYDIRECTORY', 'test.txt'); EXEC UTL_FILE.FREMOVE ('EXPORT_AUTO...

Oracle Job Scheduler Archivelog Deletion

›
CREATE OR REPLACE PROCEDURE archive_dir_setup AS archive_dir VARCHAR2(40); BEGIN EXECUTE IMMEDIATE 'SELECT DESTINATION '|| ' FRO...
Monday, April 16, 2012

Job Scheduler for EXPDP Dump

›
CREATE DIRECTORY DPUMP_DIR1 AS 'f:\expdp1213'; GRANT read, write ON DIRECTORY EXPORT_AUTO TO ldbo; begin dbms_scheduler.create_job ...

Job Scheduler for EXP Dump

›
begin dbms_scheduler.create_job (job_name => 'exp1213', job_type => 'EXECUTABLE', job_action => 'exp...
Saturday, March 24, 2012

Oracle 10g Scheduler Job Email Notification

›
1) connect sys as sysdba user and run two scripts for install and configure utl_mail package SQL> conn sys@apx1213 as sysdba Enter passwo...
Thursday, March 15, 2012

Schedule Job for Exe file

›
BEGIN dbms_scheduler.create_job( job_name => 'del_archive', job_type => 'EXECUTABLE', job_action => ...
Thursday, February 16, 2012

Job schedule compile invalid objects

›
REQUIRE SYS PRIVILIGES TO EXECUTE UTL_RECOMP BEGIN DBMS_SCHEDULER.create_job ( job_name => 'compile_invalid', jo...
Wednesday, February 8, 2012

Analyze Scheduling using oracle

›
---------------------------------------------------------------------frequency 1 day----------------------------------------- BEGIN DBMS_S...