Joined: 03 Oct 2009 Posts: 1789 Location: Bloomington, IL
Yes our application uses ESP Schedular .Pls let me know how can I acheive it through ESP?
Is not ESP a proprietary product, formerly offered by Cybermation and now incorporated into CA's Workload Automation? If your shop is licensed for the product, ought it not to have manuals? To repeat Dr. Sorichetti's question, does your shop not have an operations and/or scheduling workgroup that handles such matters? Are you trying to evade controls and proper processes to make your life easier in the short term?
Joined: 22 Apr 2006 Posts: 6258 Location: Mumbai, India
Job A deletes the rows from various tables and sometimes it crosses the 4.55 CT. In that case we have to manually terminate the job.
Apart from what has been susggested about scheduler(s), I also like to enquire about - is there no business logic involved in here - if you cancel the job in between, arbitrarily, where rows from some tables are deleted and not from others -- will not that be a problem?
Having other jobs to wait until the delete is over, would not that be a better solution?
Rather than PM's, why don't you go back to your technical people.
You have a scheduler. It can schedule jobs.
A job can contain a JES command to cancel a job.
Schedule a job to run at 04.55 which contains the appropriate cancel command.
IF your site standards do not allow JES commands to be submitted from batch jobs and IF your scheduler as no facility to assist, get your boss to give the task to the technical team's boss to resolve in a timely manner. If you cannot submit JES commands from batch, it doesn't matter what you use to attempt it (Cobol, JCL, Rice Pudding) it still won't work.
Since the limits to your task are posed by your scheduler software and its set-up, and your site standards, there really is nothing we can suggest unless you want some paid consultation from someone here.