How to clear backlog of jobs older than five days

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Need SQL for clearing backlog of jobs which are older than five days.

Environment

Release : 9.3

Component : APPLICATIONS MANAGER

Resolution

Following SQL will work clear the backlog of jobs that are older than 5 days:

delete from so_job_queue where so_start_date < sysdate -5;