BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
MSMM
SAS Employee

HI,

Does anyone know how to update job_calendar to include all days rather than only 5 days?

includes all flags and business_day_count

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
manishiiita
Quartz | Level 8

You want to use all seven days of week as business days. AGP process should be executed all seven days. In Default system, business days are defined only for five days.

 

You will have to do below two steps to do above changes:

 

  1. Business Days Count should be added for all dates, it doesn't have any count against non business days in default system. Update Business Days Count = Job_Calendar_ID.
  2. Update Rundate_Ind = 'Y' for all dates.
  3. Update Daily_Rundate_Indicator = 'Y' for all dates.

 

Hope this will be helpful. If you had some other query, please highlight.

 

 

View solution in original post

2 REPLIES 2
ElizabethKyria
SAS Employee

Hi there

 

There is no limitation on what days can be placed in the job calendar table. i.e. weekend days can be added if not included.

 

Regards

Elizabeth

 

Elizabeth Kyriacou

Business Operation Specialist

Fraud & Security Intelligence Division

Tel: + 44 (0)1628 490859 ▪ Mobile: + +44 (774) 1241863▪ elizabeth.kyriacou@sas.com

SAS ▪ 7th Floor 199 Bishopsgate ▪ London, EC2M 3TY

www.sas.com/fraudfinancialcrime

SAS® THE POWER TO KNOW®

 

manishiiita
Quartz | Level 8

You want to use all seven days of week as business days. AGP process should be executed all seven days. In Default system, business days are defined only for five days.

 

You will have to do below two steps to do above changes:

 

  1. Business Days Count should be added for all dates, it doesn't have any count against non business days in default system. Update Business Days Count = Job_Calendar_ID.
  2. Update Rundate_Ind = 'Y' for all dates.
  3. Update Daily_Rundate_Indicator = 'Y' for all dates.

 

Hope this will be helpful. If you had some other query, please highlight.

 

 

Discussion stats
  • 2 replies
  • 954 views
  • 0 likes
  • 3 in conversation