You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Export OIC job schedules to excel

in Integration 2 comments

Hello,

is there a way to export OIC job schedules to excel in a format that makes it more understandable/readable to know what jobs are going to run when? The issue that we have is, when there is ERP or OIC maintenance happening, we have plan for what jobs need to be run as an adhoc ahead of the planned down time, what jobs can be held and run after the down time, and what jobs can be held and run after the downtime but have to be run in a specific sequence.

What we have now is a spreadsheet with the job information but the schedule for the job is not helpful (for example FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21;BYMINUTE=10,25,40,55;&FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=22;BYMINUTE=10;). As this is an excel file that is dependent on someone maintaining the file we run the risk of not capturing new jobs, existing jobs having the schedule changed and the excel file not updated or additions to existing schedules and the excel file not being updated.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!