Oracle: Configuring the importer job

To configure the Oracle importer job, log in to SQLPlus as the IEE user and execute the following statement:

BEGIN

dbms_scheduler.disable( 'HVRI_IMPORT_JOB' );

dbms_scheduler.set_attribute( name => 'HVRI_IMPORT_JOB', attribute => 'job_action', value => 'hvri.hvri_import_job();');

dbms_scheduler.enable( 'HVRI_IMPORT_JOB' ); END;

/

Alternatively, you can log into Oracle Enterprise Manager, navigate to Administration > Jobs, and configure the Oracle importer job there.

Related topics:

• Oracle: Configuring the import directory

• Microsoft SQL Server: Configuring the import task