All,
Does anyone have a variable, scriptor or C Code to translate the
DS_PENDING_JOB.DAY_TIMING field? We are attempting to create some reports
to monitor DAS and the scheduled reports. This field is critical to
interpreting the scheduled document. Any and all info is greatly
appreciated.
Gene Carbonara
Braun Consulting
(312) 984-7125
Listserv Archives (BOB member since 2002-06-25)
In a message dated 99-03-30 11:15:24 EST, you write:
Does anyone have a variable, scriptor or C Code to translate the
DS_PENDING_JOB.DAY_TIMING field?
DAY_TIMING cannot be interpreted on its own. You have to look at the value
contained in the FREQUENCY column as well. From the Repository HTML
documentation (available at www.busobj.com):
***** begin quote *****
DAY_TIMING : is used to store information relative to the task execution.
For a Hourly task, if you set it to be executed hourly between 14 and 16, this
column will contain the value 14016. 0 is the separator between the StartHour
and EndHour.
Example :
If you select from 20 (8PM) to 23 (11PM), DAY_TIMING will be 20023
If you select from 20 (8PM) to 8 (8AM), DAY_TIMING will be 2008
If you select from 8 (8AM) to 20 (8PM), DAY_TIMING will be 8020
If you select from 20 (8PM) to 8 (8AM), DAY_TIMING will be 2008
if you select from 2 (2AM) to 3 (3AM), DAY_TIMING will be 203
if you select from 0 (0AM) to 13 (1PM), DAY_TIMING will be 13
if you select from 0 (0AM) to 2 (2AM), DAY_TIMING will be 2.
For a Daily task, schedule each Tuesday and Wednesday, the value will be 230.
(Monday is 1, Tuesday is 2,… Sunday is 7). It is the same algorithm used for
the Weekly case.
For a Monthly task, we use a bit field value. The last bit (32 bits are used)
stores the ëLast Day of the Monthí information.
Bit 0 is the first day of the month, Bit 1 is the second day of the month…
and so on.
Example :
if you select the day number 31, DAY_TIMING will be 2.
if you select the day number 30, DAY_TIMING will be 4.
if you select the day number 31 & 30, DAY_TIMING will be 6…
***** end quote *****
There really is quite a bit of info on the repository that is documented. Some
of it is not, and has to be interpreted. If you don’t have a copy of these
files and are trying to decipher the data stored in your repository, you
should get them. I downloaded my version, but I think that it is available on
the CD-ROM as well.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)