Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
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...
Examining and Generating JD Edwards EnterpriseOne Indexes
Within the last week, Shannon Moir has had 2 great posts about EnterpriseOne indexes that have motivated me to evaluate our database: JDE slow, missing...
How To Start SQLPlus From The Linux Command Line
Run the following commands from the Linux command line to start SQLPlus: export ORACLE_HOME=/path/to/install/dir export PATH=$PATH:$ORACLE_HOME/bin sqlplus
Pause/Resume E1 Scheduler with SQL
Below are SQL statements that can be used to Pause and Resume the E1 Job Scheduler: --*** PAUSE SCHEDULER *** update sy900.f91300 set SJSCHCTCD01='011' where...