SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

i want to track job start time and end time excluding sleep time calculation

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

i want to track job start time and end time excluding sleep time calculation

we have batch report which run daily at 12:00 ist which need small changes.

 

in the cureent batch report it calculate overall time taken as starting from 12;00 ist from till the end of job completion which include sleep time also .

can you help me how can exclude sleep time calculation so that it should provide extact batch report.

 

i am new to sas enivornment.i m bit worry to do can  anyone help me out.


Accepted Solutions
Solution
Monday
New Contributor
Posts: 3

Re: i want to track job start time and end time excluding sleep time calculation

I got the solution:
Below is the code:
Proc sql;
Select max(start_time)-max(end_time) from table name where column = sleep time:
Quit;

View solution in original post


All Replies
Respected Advisor
Posts: 4,647

Re: i want to track job start time and end time excluding sleep time calculation

Please provide example input data and desired output.

PG
Super User
Posts: 6,936

Re: i want to track job start time and end time excluding sleep time calculation

Please post code to illustrate the issue.

Especially define "sleep time". Is it time spent in sleep() functions, or the difference between CPU time and real time?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: i want to track job start time and end time excluding sleep time calculation

Thanks for reply I got the result.
I try to fetch the data from table and took the difference between two times
Solution
Monday
New Contributor
Posts: 3

Re: i want to track job start time and end time excluding sleep time calculation

I got the solution:
Below is the code:
Proc sql;
Select max(start_time)-max(end_time) from table name where column = sleep time:
Quit;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 221 views
  • 0 likes
  • 3 in conversation