How to delete a job from AJF before the newday?

rajeev5582 · Post by **rajeev5582** » 14 Apr 2010 10:54

How do i delete a job from AJF before the newday. I know how to delete it from EM GUI ie Hold-> delete. I have a request from a DBA that a certain job has to be removed for 4 days including today. Any suggestions?

philmalmaison · Post by **philmalmaison** » 15 Apr 2010 11:14

schedbloke · Post by **schedbloke** » 15 Apr 2010 11:23

I'm not aware of any other safe way of deleting a single job before New Day. I certainly wouldn't attempt deleting from the CMR_AJF table database.

I don't understand why just deleting it on the EM GUI for today and then unscheduling, or dummying it for the next 3 days won't suffice?

schedbloke · Post by **schedbloke** » 15 Apr 2010 11:28

use ctmpsm
ctmpsm -UPDATEAJF <orderid> <HOLD|FREE|DELETE|UNDELETE|RERUN|CONFIRM|FORCEOK|STATISTICS|CONDADDIN <cond> <date> <AND>|CONDADDOUT <cond> <date> <+|->|CONDDELIN <cond>|CONDDELOUT <cond>

regards
philmalmaison

There you go! - you learn something every day