JDE scheduler BULK password change with LDAP enabled

You have heaps of scheduled jobs and you need to change the password that is saved in the scheduler.  Easy, because there is a great function in admin password change, but you cannot use it when LDAP is enabled.  

This is a strange quandary too, as you need to save the LDAP password in the scheduler table.

What do you do when you need to change the password for 300 scheduled jobs?  No problems, I got you!

Just update a single record (as below, I changed the record for report 'R55HR002', version 'RBVS0010'.

Then run the following SQL:

update sy920.f91300 set sjschpwd = (

select sjschpwd from sy920.f91300 where sjschrptnm = 'R55HR002' and sjschver = 'RBVS0010')

where sjschuser like 'ZSCH%' and  sjschrptnm != 'R55HR002';

commit;

BOOM! 290 records updated. And schedules working.

Thanks to JDE for not using the job name or version name in the encryption.