How to find jobs that are in schedule greater than 2 days

anilkumar922 · New User Joined: 27 Jun 2016 Posts: 13 Location: india

Hi All,

I want to find out the jobs which are in schedule greater than 2 days in ZEKE scheduler.

I tried something like LIST PLAN JOB FIELDS (ENAME,SCHD,SELDATE) .

But it will give all jobs that are in schedule. but I want only jobs that are in greater than two days.

And also I want to store this information in Dataset. when I store this information for fields like date values are not in readable format in dataset. can you please suggest how I can overcome both issues?

Thanks in Advance,
Anil.

Nic Clouston · Posted: Tue Jun 28, 2016 2:49 pm

What do you mean by 'greater than 2 days'. This phrasing implies a time span. Do you mean 'jobs that are due to run in 2 days time'? I.E on a specific date in the future?

How about reading the documentation, asking your ZEKE support group or the vendor - as you are, presumably, paying for support.

anilkumar922 · New User Joined: 27 Jun 2016 Posts: 13 Location: india

Thanks for your reply Nic,

I want to know Jobs that are in schedule which are suppose to run 2 days back. Jobs might be not triggered with various reasons. so I want to notify those jobs.

Ex: If we are seeing schedule today (06/28/16), I want get all jobs which are suppose to run before (6/26/16) but not triggered,still they are in schedule state.

Regards,
Anil.

Robert Sample · Posted: Tue Jun 28, 2016 6:39 pm

A normal system will not have any jobs on the scheduler that are so overdue -- they should have been cleared up within 24 hours so the next daily cycle can run.

If you insist you need to do this, you need to read the Zeke documentation as you have already been told. If your site is licensed for the product, you have access to the documentation -- it might be hard copy at your site, it might be on a company internal web site, or you might have to go to the vendor and get it there. Or, contact the Zeke support staff and find out directly from them.

anilkumar922 · New User Joined: 27 Jun 2016 Posts: 13 Location: india

Thanks for your replies.
could you please suggest for below issue?

I want to store this information in Dataset. when I store this information for fields like date values are not in readable format in dataset. can you please suggest how I can overcome this issue?

Robert Sample · Posted: Tue Jun 28, 2016 7:42 pm

You need to read the product documentation and find out what your choices for date formats are.

The dates could be stored as binary fields or packed decimal fields -- neither are human-readable -- but usually there will be some way to convert them to human-readable format, but only the product documentation can tell you for sure. If you posted the hexadecimal representation of a couple of them, we can tell you the format they're in (most likely), but that won't help you get them converted.