One of the most requested items on my Help me! form is SCHEDULER. I have more than a couple of hundred responses asking me to post more on scheduler. Since i did not get any concrete questions, here are a few common questions my buddies have had for me in the past:
Q1) Why is the number of scheduler records different in F91300 and F91320?
Ans: In one word the answers is, recurrence. When we set recurrence on a job its updated in F91300 but the date-time run records that get created for that particular job are placed in F91320. So for every job with recurrence we see multiple records in F91320.
Q2) How do I know when a particular job expires?
Ans: Look at SJSCHENTIME in F91300. If it looks incorrect, that's because it is in UTC format and needs to be converted. If you need a detailed post on converting this and putting it into an excel. Shannon has this on his blog here.
Q3) Password update for User jobs on scheduler. Do we change each and every job that's been scheduled under a particular ID?
Ans: If you are not running version 8.12, the answer is an unfortunate Yes. You will indeed need to go to each job that runs under the user's id and change the password. For 8.12 and above, there's a way to update the password automatically provided the correct ESU's are in place. For 8.12 you will need to have JK22431 installed and for 9.0 you will need to have JL11051 installed.
I have always used functional accounts for specific jobs. This still brings in password changes every 90 days but at least the user id's remain consistent.
If you get a hand of F91300 and F91320, JDE scheduler is one of the easiest schedulers to manage. To understand how it works you need to know the JDE.INI settings which govern the scheduler and just these couple of tables. Happy Scheduling!
Q1) Why is the number of scheduler records different in F91300 and F91320?
Ans: In one word the answers is, recurrence. When we set recurrence on a job its updated in F91300 but the date-time run records that get created for that particular job are placed in F91320. So for every job with recurrence we see multiple records in F91320.
Q2) How do I know when a particular job expires?
Ans: Look at SJSCHENTIME in F91300. If it looks incorrect, that's because it is in UTC format and needs to be converted. If you need a detailed post on converting this and putting it into an excel. Shannon has this on his blog here.
Q3) Password update for User jobs on scheduler. Do we change each and every job that's been scheduled under a particular ID?
Ans: If you are not running version 8.12, the answer is an unfortunate Yes. You will indeed need to go to each job that runs under the user's id and change the password. For 8.12 and above, there's a way to update the password automatically provided the correct ESU's are in place. For 8.12 you will need to have JK22431 installed and for 9.0 you will need to have JL11051 installed.
I have always used functional accounts for specific jobs. This still brings in password changes every 90 days but at least the user id's remain consistent.
If you get a hand of F91300 and F91320, JDE scheduler is one of the easiest schedulers to manage. To understand how it works you need to know the JDE.INI settings which govern the scheduler and just these couple of tables. Happy Scheduling!
No comments:
Post a Comment