I have a job that needs to be scheduled for last business day of every month.
I was hoping that we could use BOBJ calendars through BOE scheduler but guess I am wrong.
One work around I can think of is to create a batch job of the job and schedule this batch file using the OS scheduler.
Before I fallback to this solution I wanted to check if I am missing anything
Is there a way to schedule a job for the last day of every month using the BODS scheduler. We are using BODS 3.2
It’s not that sophisticated. One way would be to schedule the job for the 28th, 29th, 30th and 31st of each month. Within the job check to see if the current date is the last day of the month. If not, then end the job silently. If it is then continue the job. It’s ugly.
I would do what Jim said - possibly even just schedule it daily to prevent the hassle of having to pre-schedule it for the next few years.
One of our ETL jobs is ‘controlled by the business’. They have a web interface in which they can mark when they want the ETL job to send data to an external provider/system. The job runs every day, checks the control database to see if it is required to do anything, if not - it ends again.
I wouldn’t even go as far as to say it’s ugly - it’s simple, crude perhaps, but pretty fail proof and it works.
I usually reserve ‘ugly’ for those ‘digital duct tape solutions’ of which you know that they’ll implode the moment the wind changes direction!
(BOB member since 2007-09-12)
(BOB member since 2007-01-10)