How to disable/enable fnd concurrent programs using sql script?
Dear friends,
I have requirement to put on hold all the jobs and alerts scheduled in fnd concurrent programs using sql script?
Instead of doing it from front-end, Is there a way run update table query and disable them?
approx 100 jobs are configured in concurrent manager.
Select * from apps.fnd_concurrent_programs
WHERE application_id='XXX' and ENABLED_FLAG ='Y'
select * from apps.alr_alerts
WHERE ENABLED_FLAG='Y' AND CREATION_DATE >= '1-JAN-2009' AND ALERT_NAME NOT LIKE '%ADP%'
Can someone help please......