It is currently 26 Apr 2017 12:17


Post new topic  Reply to topic  [ 1 post ] 
Author Message
PostPosted: 14 Jul 2015 5:33 
Offline
Nouveau
Nouveau

Joined: 08 Oct 2014 5:16
Posts: 14
All-

Let me give a little background of our non prod environment(dev/qa/few others..) datwarehouse scheduling env usage.So we have our dev/qa/etc.. users(few hudndreds) accessing control-M for their daily development and testing activites.They can randomly order jobs manually in to active environment based on their needs.The odate can be from past or future (for the past order date, it can well be be from prevoius year sometimes).

Tables/jobs can be put on hold ,maxwait can be 99(for few that need dependecies that span out of odate) and left unattended restricting standard new day to clean up.Thus these jobs repeatedly get loaded into ajf as part of new day impacting the license(task based) and performance.Current and tediuos procedure is admin periodically checks the environment and manually cleans up the jobs.

We would like to come up with some script to check the tables/jobs that are older than 30 days(based on ORDER TIME and not odate) and mark them as deleted.I am envisioning using combination of database view(select query against ctrlm server database-cmr_ajf table) to return jobs with order no ordered more then 30days, *p_36 and 'ctmpsm' control-M server utililities to manipulate select query results and mark them as deleted based on order id.

My Env: Cotnrol-M 7 on AIX with posgre sql.

If anyone have any other ideas for my scenario or have implemented working solution in your environment,please advise.

Thanks for reading this long post.

nriasm


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 1 post ] 

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved