It is currently 30 Mar 2017 8:57


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 05 Mar 2016 9:50 
Offline
Nouveau
Nouveau

Joined: 05 Mar 2016 9:47
Posts: 3
Hello,

I'm trying to create a viewpoint to see all jobs that have been running for more than 2 hours. The problem is that I don't even know how to get the runtime. The closest I got was by using a filter with:

Job Status = Executing
Average Runtime > 02:00:00


But unlike the alerts where "average runtime" means "current runtime", this one actually really means "average runtime" so I see jobs that historically run for more than 2 hours.

Thanks.


Top
   
PostPosted: 06 Mar 2016 3:15 
Offline
Nouveau
Nouveau

Joined: 05 Mar 2016 9:47
Posts: 3
In my tries to get this working I started using the "Start Time" field.

Job Status = Executing
Start Time < 20160305220000


This shows all jobs that started before 22:00 (jobs that have been running for more than 2 hours).

Unfortunately as you know it is not dynamic so I would need to change the filter every time I want to use it.

So I tried using the system variables but I can't get a similar example as above to work by using this:

Job Status = Executing
Start Time < %%$DATE.%%TIME


DATE should equal to 20160306 and TIME should equal to 001300 so the whole thing should be 20160306001300. With that I should see ALL jobs that started before NOW (so pretty much all jobs) but the display is empty!

I'm trying to get that working first so I can use it to substract 2 hours and get my result.


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