DBA Data[Home] [Help]

XDB.DBMS_XDBT dependencies on DBMS_JOB

Line 554: -- procedure used by dbms_jobs to automatically sync the index

550: RETURN doSync;
551: END checkSync;
552:
553: --
554: -- procedure used by dbms_jobs to automatically sync the index
555: --
556: PROCEDURE autoSyncJobByCount(myIndexName VARCHAR2, myMaxPendingCount NUMBER,
557: myIndexMemory VARCHAR2) IS
558: BEGIN

Line 565: -- procedure used by dbms_jobs to automatically sync the index

561: END IF;
562: END autoSyncJobByCount;
563:
564: --
565: -- procedure used by dbms_jobs to automatically sync the index
566: --
567: PROCEDURE autoSyncJobByTime(myIndexName VARCHAR2,
568: myIndexmemory VARCHAR2) IS
569: BEGIN

Line 603: dbms_job.submit(job, what, interval=>jInterval);

599: END IF;
600:
601: i := (jobInterval * 1000000) / 1440;
602: jInterval := 'SYSDATE+' || to_char((i*1.0) / 1000000);
603: dbms_job.submit(job, what, interval=>jInterval);
604: --dbms_output.put_line('configureAutoSync =' || jInterval);
605: END configureAutoSync;
606:
607: END dbms_xdbt;