Schedule a fixed date in Data Services management console

[Former Member]

Hi experts,
 

I want to schedule a job via the console management, I want my job to be run on 31/12 every year. I tried to use the calendar in the schedule batch job but I have only the option to select a day of a month.
 
Is there a way to specify that I want the job to be run on month 12 day 31?

I have another question : how can I get the history of a job that was executed?

 
Thank you for your help,
Sara.

[former_member187605 · Accepted solution]

Schedule your job on the 31st of each month.

Embed the complete logic in a conditional. Only execute it when date_part(sysdate(),'MM') = 12.

In this way, your job will be triggered 7 times a year, but terminate immediately in 6 out of 7 cases and only really execute once.

[Former Member · Accepted solution]

Hi Dirk,

"Embed the complete logic in a conditional. Only execute it when date_part(sysdate(),'MM') = 12."

How can I do that?

Thank you for your help,

Sara.

[former_member187605 · Accepted solution]

Select the Conditional object from the DS Designer toll palet:

Put it at the top level from your job. Cut all other objects from that level and paste them in the top half of the Conditional:

[Former Member · Accepted solution]

Hi Dirk,

If I understand, I should put my job dataflows in the conditional object using the condition :

if (sysdate(), 'MM') ='12'

Could you confirm that?

Thank you,

Sara.

[former_member187605 · Accepted solution]

No, the condition is date_part(sysdate(),'MM') = 12.

Exactly written that way.

[Former Member · Accepted solution]

Yes, of course. It's just that I forgot to write you the whole condition. Could you confirm that I have to put my job dataflows in the conditional object?

Thank you,

Sara.

[former_member187605 · Accepted solution]

Yes. That is where they have to go.

[Former Member]

Hi Sara,

Answer to your another question.

You can check the history of any job execution by checking ALVW_HISTORY meta data table generated by BODS.

Thanks,

SB

[former_member187605]

Or get it from the DS admin console (cf. Daya's first screenshot).

[Former Member]

Hi Swapnil,

Where can I find ALVW_HISTORY meta data table ?

Thank you,

Sara.

[Former Member]

Hi Sara,

You can find that table in same repository where you are logging for BODS.

While login in BODS you must be choosing the repository,so you need to check the same repository.

Ask you DBA for password of repository where BODS installed.

Thanks,

Swapnil

[severin_thelen]

Hello Sara,

you have to select the BOE scheduler. After that you can create a custom calendar in the BOE CMC. In this calendar you could create monthly or weekly dates, but you could create single dates to.

So you could select the 31.12.2015, click next year, 31.12.2016 and so on. I know, that is not the best practice, because you scheduler will end someday, but I do not know another way.

Regards

Severin

[Former Member]

Hi Severin,

Thank you for your response,

Could you please tell me the steps to create this custom calendar?

Regards,

Sara.

[severin_thelen]

1. Create Job Scheduler in the DS Management Console
2. Activate this Scheduler (this create a folder in BOE)
3. Open CMC
4. Create calendar (should be in the second column on the homescreen)
5. Open the public folder (in the CMC), there should be an folder 'Data Services'
6. Open DS folder and schedule the program
7. Use you previous created calendar in the repeat tap

I hope you understand every step.

Regards

Severin

[Former Member]

Hi Severin,

Thanks for your help,

I did not find a 'Data Services' folder in the CMC public folder. Do you have any ideas about that?

Best regards,

Sara.

[severin_thelen]

Hello Sara,

you have to create and activate the job scheduler first. After that there should be a DS folder in the CMC.

Regards

Severin

[Former Member]

I again,

Sorry for being late, I have already a number of jobs that are scheduled and running. So, I should have this folder, but I did not find it

Regards,

Sara.

[DayaJha]

Hi Sara,

As you mentioned you want  to use Data Services management console for execution of BODS Jobs.

Please refer the below steps for creation of schedule using Data Services management console:

Step I: Login in Data Services management console, go to Administrator

Step II: Click on Batch and select Local repository where you want to set the schedule for batch Job

Step III: Now go to batch Job Configuration and click in Add Schedule for specific job you want to set the schedule to run

Step IV: Now schedular page will open put the details:

Schedule Name: Test

Active: Enable that Option

Select a schedular:

BOE Or Data Services

Select scheduled day(s) for executing the job: Here i selected 12 &  31 for every month and also select recurring for every month

Step V: Now Select scheduled time for executing the jobs

Step VI: And also select Select job execution parameters that you want to see in Job execution Logs

Step VII: If any substitution parameter is associated with Jobs then update it

Step VIII: Click on Apply

Step IX: Now you can see the Batch > Batch Job Schedules is created

Currently i am not activated that batch job so please check the active box when you are creating schedule.

Hope this will help !!

Thanks,

Daya

[Former Member]

Hi Daya,

First of all, thank you for you response.

May be I was not clear about my demand, I want to have my job run every  31 of december.

Thank you,

[DayaJha]

Hi Sara,

Then Use BOE Schedular or create Batch Script/ SHELL Script to execute the Job.

Thanks,

Daya