sysman@emrep.marte> SELECT
  LPAD( '-', 150, '-' ) LINHA
  ,J.JOB_NAME
  ,J.TARGET
  ,J.SCHEDULED_TIME
  ,J.START_TIME
  ,J.FREQUENCY_CODE
  ,J.INTERVAL
  ,J.DEFINITION
FROM  USER_JOB.GRID_JOBS_SCHEDULED J
WHERE JOB_NAME LIKE '%DWH1N%'
ORDER BY JOB_NAME
/

------------------------------------------------------------------------------------------------------------------------------------------------------
SET PAGESIZE 1000 HEADING OFF FEEDBACK ON TIMING ON SERVEROUTPUT ON
WHENEVER SQLERROR EXIT SQL.SQLCODE
ALTER SESSION SET query_rewrite_enabled=FALSE;
select instance_name from v$instance;
commit;
SELECT 'INICIO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
execute usr_job.CRG_DWH1N_DWORCAMENTO_DIARIO;
SELECT 'TERMINO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
commit;
exit;

------------------------------------------------------------------------------------------------------------------------------------------------------
SET PAGESIZE 1000 HEADING OFF FEEDBACK ON TIMING ON SERVEROUTPUT ON
WHENEVER SQLERROR EXIT SQL.SQLCODE
SELECT 'INICIO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
--backup ft_favorecido,ft_favorecido_est e ft_execucao_contas
host /prg/oracle/admin/dwh1n/rotinas/expdp_tabs_orcamento.ksh
SELECT 'INICIO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
--Trunca as tabelas dist_uf e dist_municipio
execute usr_job.crg_dwh1n_dworcamento_truncate;
SELECT 'INICIO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
--Carrega as tabelas dist_uf e dist_municipio via sqlloader
host /prg/oracle/admin/dwh1n/rotinas/ex_func_distmun.ksh
host /prg/oracle/admin/dwh1n/rotinas/ex_func_distuf.ksh
SELECT 'INICIO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
--Executa a carga_inc_fato_favorecido
execute usr_job.crg_dwh1n_dworcament_ft_diario;
SELECT '---Procedure OK---' FROM DUAL;
SELECT 'TERMINO EM : ' || to_char(sysdate,'DD/MM/YYYY HH:MI') FROM DUAL;
commit;
exit;