Horje
oracle next run dates Code Example
oracle next run dates 
SELECT OWNER, JOB_NAME, JOB_TYPE, LAST_START_DATE,
       LAST_RUN_DURATION, NEXT_RUN_DATE, STATE,
       REPEAT_INTERVAL
FROM DBA_SCHEDULER_JOBS
WHERE JOB_SUBNAME IS NULL
  AND NEXT_RUN_DATE IS NOT NULL
  AND STATE = 'SCHEDULED'
  AND NEXT_RUN_DATE < trunc(sysdate) + 1
ORDER BY NEXT_RUN_DATE;



Sql

Related
set statiscis on in sql server Code Example set statiscis on in sql server Code Example
oracle drop column Code Example oracle drop column Code Example
mysql password error create datbase Code Example mysql password error create datbase Code Example
alter user root mysql Code Example alter user root mysql Code Example
sql server user permissions and roles Code Example sql server user permissions and roles Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje