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
Separate Date and time Feld from Query on Control-M
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
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
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....
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....
- zailaiboke
- Nouveau
- Posts: 3
- Joined: 01 Aug 2013 12:00
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
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