How do you start?DBMS_Job for the MarkView Document Export server? How do you confirm that it is up? 4017
- 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; /
- 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.
- 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).
- 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; /
Keywords: dbms, job