How to include the time stamp to monitor the time taken load each table.

[#1]

Hi Every One

I need to monitor the time that how long it takes to load a table for example

I have Say 5 Tables

Table 1     Table 2     Table 3    Table 4      Table 5

A                D            G             J              M

B                E            H             K              N            

C                F             I              L              O

If I Load all the tables I need to monitor the time taken to load each table . Usually we could view only the full time taken to reload , but i want the time for each partition (i.e For Each Table )

Kindly Suggest me

Thanks in Advance

[marcus_sommer]

Have a look here: Re: How get RowNo() inside a module macro

- Marcus

[jonathandienst]

Hi

The Now(1)  function returns the data and time at the function call. You can combine this with Trace statements to record the time in the reload log, or load the time into a table that can be exposed in your model and/or saved to a qvd (eg for a process status qvw to load).

for a trace:

Let vTime = Time(Now(1), 'hh:mm:ss');

Trace Table A end: $(vTime);

for a table, after each table load:

Log:

LOAD 'Table A' As Object,

     Time(Now(1), 'hh:mm:ss') As CompleteTime

AutoGenerate 1;

Each statement would log the respective table name or number. At the end, you could STORE Log to a qvd. You can also expose the contents in the front end (eg on a log page).

HTH

Jonathan