Process Info

[Gabriel]

Hi,

In my application I have several jobs to executed (called from one
procedure) :

- Deleting table A (temp table)
- Deleting table B (temp table)
- Deleting table C (temp table)
then
- Inserting new records to table A (from select query)
- Inserting new records to table B (from select query)
- Inserting new records to table C (from select query)

Is it possible to have a form that inform the users what is the status of
the job executed, for example :
Current job executed :
- Deleting table A (completed in xxx seconds)
- Deleting table B (completed in xxx seconds)
.....

I need this information to monitor the jobs performance and future tuning
process.

TIA

 

[Nikos Yannacopoulos]

Gabriel,

Some simple VBA code will do it nicely. There are two ways you can go,
either (a) use a single label and change the caption at each step, or (b)
place one static label for each step on the form, and use the code to
highlight (cold, different colour etc) the label pertaining to the step
being executed each time. The latter has the advantage of showing not only
the current step, but the progress within the whole process as well.

HTH,
Nikos