Last Execution time for each QVD generated

[ivandrago]

Hi,

I want to know the last eexcution time and how long the Task took generate the QVD file? Is this possible?

Thanks

[sundarakumar · Accepted solution]

PFA, I the start and end time are same in the app as it is a very small application.

I have used now as the flag. While concatenating all the data in the main application u can use the latest time as flag.

I have shown the data creation for one qvd. similar tables should be created in the other qvd's also.

all these qvd's that are created an be concatenated in the main application, which can be used as the master qvd data details.

Hope this helps.

-Sundar

[its_anandrjs]

You can load your table like below

It is a example do changes from your own table

LET vStart = Now();

LET Tablename = 'Customer';

$(Tablename):

SQL SELECT *

FROM Customers;

LET vEnd = now();

Let vtottime =TIME(vEnd-vStart,'hh:mm:ss');

LOAD * Inline

[

Start,End,Tablename,ExecutionTime

'$(vStart)','$(vEnd)','$(Tablename)','$(vtottime)'

];