How To Disable Client Package Deployment
Share
If you have a development client that has been neglected and JDE wants you to install 15 update packages but all you really want to do is install the latest and greatest full package, you could select each row individually and click the “Decline” Row Exit 15 times.
I don’t like repetition and avoid it at all costs, which means that for some of my “shortcuts” take a long time to come up with and may or may not be worth the time saved. Well, that’s why I put it here. Maybe someone else can save some time even if it did take me 2 hours to come up with a 5 second fix for a 30 second problem.
Here is the SQL to remove the client deployment records from the F98825 so you don’t have to click “Decline” so many times:
DELETE FROM SY910/F98825 WHERE UPJDEPKGNM LIKE 'DVFU%' AND UPMKEY LIKE 'E1%' AND UPINPKST=20
Author
Stewart Schatz
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Average Rating