It is currently 20 Jul 2017 10:39


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Command to extract data
PostPosted: 17 Jan 2014 11:18 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Jan 2014 9:00
Posts: 6
Is there any command to extract job list for a particular day and time.

eg : I need a list of jobs that run on 17th 2PM to 5PM.


Top
   
 Post subject:
PostPosted: 19 Jan 2014 4:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 8:00
Posts: 48
You can use the table cmr_ajf ( if the jobs are in active network )

u can use a query like

select jobname,startrun from cmr_ajf where start run between '01/17/2014 14:00:00' and '01/17/2014 17:00:00';

_________________
Anirudh


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

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 1 guest


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