It is currently 01 May 2017 10:31


Post new topic  Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 04 Dec 2012 1:25 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Jan 2010 9:00
Posts: 26
Hi there, i have an issue regarding Reporting os Sucess Of Jobs ended OK.
I run this query against a View of ours called CUST_ALLJOBS.

Select JOB_NAME,MEMNAME,ODATE, elapsed, start_time, end_time
FROM CUST_ALLJOBS where STATUS like 'Ended OK' and GROUP_NAME like 'DW-SCADA' and ODATE like '1211%'
and JOB_NAME like 'DIARIO_NEW'

The result is like this:

DIARIO_NEW Diario.bat 121105 20121106035931 20121106060638

But our costumer needs to have separated the date and time in 2 columns. Anyone have done this? Or exist some other Table where i can have the same results but with Date and Time separated.

Regards,

osafr71


Top
   
 Post subject:
PostPosted: 04 Dec 2012 3:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 8:00
Posts: 807
Location: Varese - Italy
For this kind of report why you dont use the Reporting Facility ?
:D

But you are true: the problem of the start time/end time format remain. You can export the report on xls files and in excel filtering the column values showing only time ?

Regards


Top
   
 Post subject:
PostPosted: 04 Dec 2012 3:18 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Jan 2010 9:00
Posts: 26
Hello. You are correct, but my problem is our Service Manager doesn't won't to "spent any time " formatting Excel.

The Reporting Facility i have tested some solutions, but how cai i pass de Last Month option?
This report run's as first day of each month and the result must be the data of previous month. It's possible to pass %%CALCDATE %%MONTH -1 ?

osafr71


Top
   
 Post subject:
PostPosted: 04 Dec 2012 3:28 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 8:00
Posts: 807
Location: Varese - Italy
For the date, if you use the active jobs report you can create a template that extract not the current AJF but the previous day. Then you schedule the report at the first day of the month.

For dates formats, you can define a macro in the excel sheet, so that can be executed when the sheet is opened: no work for the users....
:D


Top
   
 Post subject:
PostPosted: 01 Aug 2013 7:44 
Offline
Nouveau
Nouveau
User avatar

Joined: 01 Aug 2013 8:00
Posts: 3
For the date, if you use the active jobs report you can create a template that extract not the current AJF but the previous day. Then you schedule the report at the first day of the month.

For dates formats, you can define a macro in the excel sheet, so that can be executed when the sheet is opened: no work for the users....
Very Happy




________________________________________________
FIFA Ultimate Coins


Top
   
 Post subject:
PostPosted: 28 Jan 2014 5:09 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 8:00
Posts: 48
this myt help u in the query...

to_char(to_timestamp(trim(timestmp)
, 'YYYYMMDDHH24MISS') - numtodsinterval(elaptime / 100
, 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') as start_time
, to_char(to_date(trim(timestmp), 'YYYYMMDDHH24MISS')
, 'YYYY-MM-DD HH24:MI:SS') as end_time

_________________
Anirudh


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 6 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:  
cron
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