Skip to main content
Kofax

MarkView All Components - Configuring DayTick to Run On a Specific Schedule

Summary

12250

Applies To

  • ERP System: All
  • MarkView Version: All

Behavior

It is sometimes required to configure the DayTick job to run on a specific schedule.

DayTick can be configured by your database administrator (DBA) to run on a specific schedule of your choosing.

Know Causes

MarkView Administrators require to schedule the DayTick job.

Resolution

Below is just one example for configuring DayTick to run on a schedule. In this example, DayTick is configured to run Monday- Friday at 2am:

In the MarkView schema, you can remove the existing job and test the following:

--2AM Mon-Fri
set serveroutput on size 100000
declare
-- dbms_job.submit will use the following two variables: 
l_job_id number; -- an output parameter
l_job_code varchar2(2000); -- an input parameter begin
l_job_code := 
'begin
MVT_Workflow_Utility.AlertEventFromDBMSJob(EventName=>''DayTick''); 
end;';
dbms_job.submit( 
job => l_job_id, 
what => l_job_code,
Next_Date => trunc(sysdate) + 2/24,
Interval => 'trunc(least(next_day(sysdate, ''Monday''), 
next_day(sysdate, ''Tuesday''),
next_day(sysdate, ''Wednesday''), 
next_day(sysdate, ''Thursday''), 
next_day(sysdate, ''Friday''))) + (2/24)'
);
dbms_output.put_line('Day Tick Job ID: ' || l_job_id); 
end;
/
Note: Be sure to issue a commit; after you run this code.

MarkView leverages Oracle's dbms_job functionality for the DayTick job. Consult with your DBA if you have specific questions or issues with Oracle's dbms_job functionality, and always perform tests in a Non-Production environment prior to making changes to Production.

Keywords: Day-Tick, Day Tick