DBMaint Fails With Exit Code 1 When Executing archive_jobs

Products

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

Issue/Introduction

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?

Environment

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

Resolution

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.