When I execute autosys_secure, I do not have access to EDIT/EXEC superuser options.

Document ID : KB000003984
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After getting some errors to create super users in Autosys, now when I try to relaunch autosys_secure I can no longer access the Edit and Exec super user options. 

Environment:
Autosys 11.0 on Unix/Linux
Cause:

Due to some database errors, tables mdbadmin.ujo_keymaster and mdbadmin.ujo_alamode  might be corrupt

Resolution:

The solution is to update the DB using the following queries:

  1. Truncate table mdbadmin.ujo_keymaster;
  2. Update mdbadmin.ujo_alamode set int_val=0 where type = 'JOB';
  3. Update mdbadmin.ujo_alamode set int_val=0 where type = 'EVT';
  4. Delete from mdbadmin.ujo_alamode where type = 'SEC'; commit;