Sleep deprived? Learn how to automate Hyperion Planning tasks without Server Access. Chapter II, Job Scheduling
Unless you are a very early morning person, you don’t want to wake up at 5:00AM in the morning to import data or metadata in a Planning Application. Fortunately, you can schedule Jobs from the Oracle Hyperion Simplified Interface. First you need to create a Job, how to do it? Check out this post. In this article I am going to share with you who to schedule Jobs to improve your own schedule and your work/life balance ®.
Scheduling a Job
Once your Job is created, it is rather simple to schedule it. Open the Console, click on the Agenda Icon, and select “Schedule Jobs”
Select when you want to execute your Job, give it a name, then select the recurrence pattern: Once, Daily, Weekly, Monthly, or Yearly. If you select “Run now”, you won’t be able to have any form of recurrence.
Select the Job you want to schedule, our case is simple, we only have one “Import Job” created:
Once you’re done select “Next”, Review your Job then you can click “Finish”
Once you are done, you will be taken back to the Console where you can check the execution of Jobs, Edit, or Delete Schedules:
Click on a Scheduled Job to see details, in our case we see that there is no “Scheduled End Time” defined:
Click on the Settings Wheel, select Edit and add an End Date.
Scheduling any type of Job (Import or Export, Data or Metadata) will follow the same process.
Review the execution of a Job
The Console shows “Pending Jobs” as well as your “Recent Activity”:
When you click on a Recent Activity item, you can access information about the execution. By Default you only see errors, but you can also select to see Warnings, Info, or All messages
When you select “All”, you have something looking like an Essbase log:
You can also Download the Exported file:
You might wonder, why did the Import Job I created earlier failed?
I click on the hyperlink next to Job Status and I see that the file I was pointing did not exist.
this is because I wanted to import data before I exported it…
Migrating Jobs and Schedules
Another good thing is the possibility to use LCM to backup, export, and import Jobs and Schedules.
Schedules are grouped by frequency:
This method is the way to go if you have PBCS but I also find it very useful if you have an on premise infrastructure.
It is one place to go to schedule and review Job execution, it also makes migration from one environment to another more simple as system admins don’t need to see you playing with Windows Schedules, cron, or Control M.
Last, I have seen many admins not having Server Access, it makes scheduling challenging and this is the solution for them.