Deleting Enterprise Server Jobs from the queue in Enterprise Server 9

Note. This article contains information about functionality that is to be introduced in the upcoming release of Enterprise 9.6.0. This information is preliminary and may be incomplete or incorrect; use it as a reference only.
The article will be complete at the time of the Enterprise 9.6.0 release. Last update: Tuesday, July 21, 2015..

When Enterprise Server Jobs enter the Server Job queue, they will stay there indefinitely.

When the queue holds too many Jobs though, the performance of database queries can be negatively affected and the overview of Jobs in the Job Queue becomes difficult to manage.

It is therefore important to clean up the queue on a regular basis.This can be done either manually or automatically.

Figure: The Enterprise Server Job Queue page with multiple Server Jobs listed.

Deleting Jobs manually

Step 1. In Enterprise Server, access the Enterprise Server Job Queue page.

Step 2. Select the check box in front of one or more Server Jobs that need to be deleted.

Tip: To select all Jobs on the page, click Select All at the bottom of the page.

Step 3. At the bottom of the page click Delete Selected and confirm the action.

The selected Jobs are deleted.

Deleting Jobs automatically

Info: This feature requires Enterprise Server version 9.6.0 or higher.

Enterprise Server Jobs can be automatically and periodically cleaned up by Enterprise Server. This is done by configuring the Enterprise Server Job named "AutoCleanServerJobs".

Step 1. Access the Enterprise Server Job Config page.

Step 2. Click AutoCleanServerJobs.

The configuration page for that Job appears.

Step 3. Set its options:

• Attempts: Enter a number which specifies how many attempts should be made to re-try the job until running the job should be canceled.
• Username: Choose a user with system admin privileges.
• Active: Select to activate this job.

Step 4. Click Update.

Step 5. Configure after how many days the Job should run and (optionally) which Jobs should be deleted by doing the following:

Step 5a. In the configserver.php file for Enterprise Server, locate the Enterprise Server Job Auto Cleanup section.

// ----------------------------------------------------------------------
// Enterprise Server Job Auto Cleanup
// ----------------------------------------------------------------------
 
// Automatically deletes Enterprise Server Jobs of a particular status 
// when they become older than a specified number of days.
 
// AUTOCLEAN_SERVERJOBS_COMPLETED:
//    Deletes Enterprise Server Jobs of status 'Completed'. 
//    Default value is 14 days, which means all completed jobs in the 
//    queue that are older than 14 days will be deleted.
//    When set to zero (0), this feature is disabled.
define( 'AUTOCLEAN_SERVERJOBS_COMPLETED', 14 );
 
// AUTOCLEAN_SERVERJOBS_UNFINISHED:
//    Deletes Enterprise Server Jobs that have a status other than 
//    'Completed'. Default value is 30 days, which means all jobs 
//    in the queue that were never picked up, failed or not completed 
//    for some reason, and that are older than 30 days will be deleted.
//    When set to zero (0), this feature is disabled.
define( 'AUTOCLEAN_SERVERJOBS_UNFINISHED', 30 );

Step 5b. Do one of the following:

• To delete Enterprise Server jobs of all statuses (such as "Completed", or "Planned"), configure the time interval (in days) for 'AUTOCLEAN_SERVERJOBS_COMPLETED' and 'AUTOCLEAN_SERVERJOBS_UNFINISHED'.
• To only delete Enterprise Server jobs that have a "Completed" status, configure the time interval (in days) for 'AUTOCLEAN_SERVERJOBS_COMPLETED'.
• To only delete Enterprise Server jobs that have a status other than "Completed", configure the time interval (in days) for 'AUTOCLEAN_SERVERJOBS_UNFINISHED'.

Tip: Set either option to 0 (zero) to disable it.

Step 6. Make sure that an Enterprise Server instance is set up to handle the AutoCleanServerJobs Server Job.

Step 6a. Access the Enterprise Server Maintenance page for the Enterprise Server instance.

Step 6b. Set the "Handle Jobs" option to All or choose Specified and choose AutoCleanServerJobs from the list.

Note: For more information about setting up Enterprise Server instances, see Working with Enterprise Server Jobs in Enterprise Server 9.

Step 7. Set up a recurring Job schedule as explained in Working with Enterprise Server Jobs in Enterprise Server 9. Make sure to use the following cURL argument: "http://127.0.0.1/Enterprise/jobindex.php?createrecurringjob=AutoCleanServerJobs".

Example: To create an AutoCleanServerJobs job in the Enterprise Server Jobs queue at 23:00h on weekdays only, to be picked up by any of the listed servers, use the following time schedule: Hours: 23, Minutes: 0, Days of the week: 1,2,3,4,5, Months: *, Days of the month: *.

Step 8. Run the Server Jobs test on the Health Check page for Enterprise Server.