DBMaint Fails With Exit Code 1 When Executing archive_jobs
search cancel

DBMaint Fails With Exit Code 1 When Executing archive_jobs


Article ID: 14379


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent


When the Scheduler runs DBMaint, the following messages occur:

From The Scheduler Log:

05/22/2017 03:33:27] CAUAJM_E_20220 DB Maintenance returned an exit code of 1.  

[05/22/2017 03:33:27] ______________________________________________________________________________ 

05/22/2017 03:33:27] CAUAJM_I_40265 ****<Date:05/22/201703:33:27>**** 

[05/22/2017 03:33:27] CAUAJM_I_40245 EVENT: ALARM ALARM: DBMAINT_FAILURE TEXT: <Error encountered while running DBMaint script!> 


From $AUTOUSER/out/DBMaint out:

CAUAJM_W_10406 Control Execute Access Denied! 

CAUAJM_W_10439 No policies granting access to resource. 

CAUAJM_W_10440 Class: as-control Resource: PR1.ARCHIVE_JOBS User: SYSTEM Access: execute 


What is the cause of the message and how can it be prevented?


Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option


The DBMaint script runs the archive_jobs command. Access to this command is controlled by the ARCHIVE_JOBS WAAE policy in EEM under the as_control resource class.  

The user that runs the Scheduler needs to be granted 'execute' in the ARCHIVE_JOBS policy.  In Windows this is usually SYSTEM. For Unix, it is typically the user that was specified as the application owner during installation.