Friday, February 12, 2021

Dealing with Oracle jobs 


Views:

dba_jobs_running - lists all jobs that are currently running in the instance.

dba_jobs -  describes all jobs in the database.


To manage jobs as sys users for the jobs created by other users

use package dbms_ijobs to remove or mark other user jobs broken


To manage jobs logged in as user who submitted jobs

use package dbms_jobs 




Oracle E-business suite logs clean up

 Oracle E-business suite logs clean up #!/bin/bash cd $EBS_DOMAIN_HOME find $EBS_DOMAIN_HOME -type f -path "*/logs/*.log?*" -mtime...