Quick Tip: Change A Scheduled Job’s Time Zone Using SQL

Read Time:40 Sec

SQL Ninja

If you work with multiple time zones, especially if one uses Daylight Saving Time and the other does not, it can be useful to have scheduled jobs setup using the appropriate time zone.

This can be done by creating separate versions of the P91300 – Scheduled Jobs application.

After running with multiple versions of the P91300, you may find it necessary to move or copy a scheduled job from one time zone to the other. Unfortunately, there is no way to do this using the application.

So, not to be denied, I figured out a little SQL that can be used:

UPDATE SY900.F91300 
SET SJTIMEZONES=11 --(UTC+08:00) in UDC H91/TZ
WHERE SJSCHJBNM='TEST JOB'

It’s quick. It’s dirty. But… Hey! That’s one of the beautiful things about SQL.

 

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

E1Tips.com Previous post Basics of the Linux Top Command
Next post Quick Tip: Decline All Update Packages Using SQL