Here is something that helped me:
Dump them all into excel, that is a good start.
The following can be used to decipher the recurrence type: (SJSCHRCRTYP)
|
01 |
Custom Recurrence |
|
11 |
Daily - Mode 1 |
|
12 |
Daily - Mode 2 |
|
21 |
Weekly - Mode 1 |
|
31 |
Monthly - Mode 1 |
|
32 |
Monthly - Mode 2 |
|
41 |
Period - Mode 1 |
|
42 |
Period - Mode 2 |
|
51 |
Yearly - Mode 1 |
|
52 |
Yearly - Mode 2 |
Here are some excel formlas to help you convert the EPOCH (of course bespoke JDE version, which is in minutes) to standard date and time.
|
time scheduled (UTC) |
JDE Vers x 60
|
start time (UTC) |
With DST start time |
|
17964814
|
1077888840
|
1:34:00 PM
|
11:34:00 PM
|
|
17964817
|
1077889020
|
1:37:00 PM
|
11:37:00 PM
|
|
17964933
|
1077895980
|
3:33:00 PM
|
1:33:00 AM
|
|
17964934
|
1077896040
|
3:34:00 PM
|
1:34:00 AM
|
|
17964935
|
1077896100
|
3:35:00 PM
|
1:35:00 AM
|
|
17964813
|
+I7*60
|
=+(J7/86400)+25569
|
=+K7+TIME(10,,)
|
The formulas are in the last row.
The combination of the recurrence type, the start time and the table below (showing you weekday / day of month runtime options will help.
Monthly will have a value for the day of the month in SJSCHDAY
Weekly look for the columns that are populated (SJTUESDAY etc)
Here are the table columns
SJSCHJBTYP NCHAR(2)
SJSCHJBNM NOT NULL NCHAR(30)
SJSCHRPTNM NCHAR(10)
SJSCHVER NCHAR(10)
SJPROCNAME NCHAR(10)
SJSCHSTTIME NUMBER
SJSCHENTIME NUMBER
SJNUMJOBOCC NUMBER
SJCURRUNCNT NUMBER
SJMAXRESUB NUMBER(15)
SJSCHJBSTAT NCHAR(2)
SJSCHENHV NCHAR(10)
SJSCHJOBSVR NCHAR(30)
SJSCHUSER NCHAR(10)
SJSCHPSWD NCHAR(10)
SJSCHROLE NCHAR(15)
SJJDELOG NCHAR(1)
SJTRACING NCHAR(1)
SJUBELOGLVL NCHAR(1)
SJSCHPI NCHAR(1)
SJPNTR NCHAR(30)
SJJOBQUE NCHAR(10)
SJRESBONERR NCHAR(2)
SJRESBTIME NUMBER
SJINPRTMOTPY NCHAR(2)
SJINPRMAX NUMBER
SJINPRTMOUT NUMBER
SJJOBEXPIRE NUMBER
SJSCHRCRTYP NCHAR(2)
SJCO NCHAR(5)
SJSCHNUMMNS NUMBER
SJSCHNUMHRS NUMBER
SJSCHNUMDY NUMBER
SJSCHNUMWKS NUMBER
SJSCHNUMMN NUMBER
SJSCHDAY NCHAR(1)
SJWEEKDAY NCHAR(1)
SJWEEKEND NCHAR(1)
SJMONDAY NCHAR(1)
SJTUESDAY NCHAR(1)
SJWEDNESDAY NCHAR(1)
SJTHURSDAY NCHAR(1)
SJFRIDAY NCHAR(1)
SJSATURDAY NCHAR(1)
SJSUNDAY NCHAR(1)
SJTIMEZONES NCHAR(2)
SJDAYLIGHTSV NCHAR(1)
SJDSAVNAME NCHAR(10)
SJSCHCTCD01 NCHAR(6)
SJSCHCTCD02 NCHAR(6)
SJSCHCTCD03 NCHAR(6)
SJSCHCTCD04 NCHAR(6)
SJSCHCTCD05 NCHAR(6)
SJSCHFU1 NUMBER
SJSCHFU2 NUMBER
SJSCHFU3 NCHAR(30)
SJSCHFU4 NCHAR(30)
SJUSER NCHAR(10)
SJPID NCHAR(10)
SJJOBN NCHAR(10)
SJUPMJ NUMBER(6)
SJUPMT NUMBER
SJSCHPWD BLOB()
1 comment:
Thank you for sharing this. It has helped me with putting the scheduled jobs in an easier to read format in a spreadsheet.
Post a Comment