Instructions for starting DBMS_Job for the MarkView Document Export server

Summary

1. Start the Export Server:
   To start the Export server, call mv_export_admin.CreateJob using code similar or identical to the following:

   declare
       JobID Binary_Integer;
   begin
   --- Start up the Export Server.
       mv_export_admin.CreateJob(Job => JobID,
       ServerName => 'MY_SERVER',
       StartTime => sysdate,
       PollingInterval => 5,
       CommitWork => true,
       UseFileLogging => true,
       LogNormalMessages => true,
       LogDirectory => ’/tmp/ExportServer’,
       LogFilename => ’MyExportServer.log’
   );
   end;
   /

2. Lifetime of Server:
   The Export server will stay up until you explicitly terminate it by calling mv_export_admin.RemoveJob. Because CreateJob is a wrapper around DBMS_JOB, the Export server will automatically restart when the database restarts.
3. Confirming that Server is Still Up
   Since CreateJob uses the DBMS_JOB infrastructure, a system administrator can determine whether the Export server is still running by issuing the following command and examining the output:
   sql> select job, what from user_jobs;
   When looking at the output of that query, the relevant job is the one that calls the following routine: mv_export_svr.PollAndProcessAll 
   and specifies the relevant server (for example, MY_SERVER).
4. Terminating the Server
   If you ever need to terminate the server, you must call the mv_export_admin.RemoveJob procedure. This procedure takes only a single argument, which is the job number.
   For example, to terminate the server whose job number is 168, the system administrator would issue the following command:

   sql> begin
   mv_export_admin.RemoveJob(168);
   end;
   /