search cancel

How to clear backlog of jobs older than five days 

book

Article ID: 216303

calendar_today

Updated On:

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;