Hi

I have a problem with jobs that I schedule to run - they dont seem to be executed at all. How do I check what's gone wrong?

The process ora_snp0_ is running.

If I execute the job manually using dbms_job.run(job#) it works fine. This is the job I was talking about:

SQL> r
1* select * from user_jobs

JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE
------------------------------ --------- -------- --------- -------- ---------
NEXT_SEC TOTAL_TIME B
-------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
CURRENT_SESSION_LABEL
--------------------------------------------------------------------------------
CLEARANCE_HI
--------------------------------------------------------------------------------
CLEARANCE_LO
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV
----------------------------------------------------------------
15 REPTEST REPTEST
REPTEST 13-APR-01 17:42:59 00-DECEMB
00:00:00 1 N
sysdate+1/(1440)
0
dbms_refresh.refresh('"REPTEST"."RG_REPTEST"');



NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENC
Y='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LAN
GUAGE='AMERICAN' NLS_SORT='BINARY'
0102000200000000