Skip to main content
Kofax

MarkView Administration : How to Manually Create the MV_Export_Email_Failure.CheckEmailsNotSent DBMS Job

Summary 

4700

Applies To

  • ERP System: Oracle, SAP, Peoplesoft
  • MarkView Version: 6.x and above.

Resolution

  • This job checks the status of any email document request within the export request history table. If any email document request fails in the export server, then the Email Failure Notification job will send an email to the sender to notify them of the email failure. The createjob procedure that will help create this job is within the mv_export_email_failure_admin package.
    You can call the createjob procedure using a script similar to the one here below:
    set serveroutput on size 1000000
    declare
        JobID Binary_Integer;
    begin
        mv_export_email_failure_admin.createjob(Job                => JobID,
                                                QueueName          => 'DEFAULT_EXPORT_QUEUE',
                                                StartTime          => sysdate,
                                                PollingInterval    => 60,
                                                CommitWork         => true,
                                                UseFileLogging     => true,
                                                LogNormalMessages  => true,
                                                LogDirectory       => '/usr/tmp',
                                                LogFilename        => 'Mv_export_email_failure.log');
        dbms_output.put_line('Job # ' || to_char(JobID));
    end;
    /
    
    .

Keywords: dbms, job