Month End Schema Scheduling

[Spd_03]

Hi, 

I would like to load a schema only at the end of the month, but Incorta does not offer the ability to schedule it for that time.

Example : We may have 28, 29, 30, or 31 days this month. With Incorta, we can schedule on a specific day instead of straight on the last day of the month.

Can anyone please help me out.

Thanks & Regards
Saichandra Deshpande


 

[RADSr · Accepted solution]

That does seem to be a gap in the scheduling UI, so if I were faced w/ that requirement I'd look to Windows and schedule a task to do this:

https://docs.incorta.com/6.0/references-api-load-schema-endpoint-v1

[Spd_03]

@RADSr , Thank you for the reply. It seems due to some security issues we're not permitted to use Public API.

[Adetweiler]

I came here to ask for the same thing - it would also be great for dashboard scheduling. We are being asked to stop using crntab for security concerns and if we could have this added it would reduce the necessity.

Better yet, we have loaded our accounting calendar into the gregorian calendar - that is for a year forward we identify the accounting day of the month. We run some reports five days before the 1st day of accounting close, other on the day close day of the month. These do not always correspond to the first of the month, the second of the month, etc. because of weekends and holidays. Because we dont know this, we run for a range of days (sort of wasteful). So for example a schema needs to be scheduled on accounting day -2 but because it is a range we schedule from the 27 -30th to cover all months. Best case is we have the ability to use a data column loaded into the physical schema of incorta to use a schedule. I can show it readily as needed. Pipe dream i know,