DBMaint Fails With Exit Code 1 When Executing archive_jobs

Document ID:  TEC1323288
Last Modified Date:  06/15/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA Workload Automation AE


  • CA Workload Automation AE:Release:11.3.6


  • CA Workload Automation AE (AutoSys):ATSYS

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?


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.



Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >