by Vikto » Mon, 02 Apr 2001 08:46:04
Connection.Execute SQL_String
sometimes takes more than 5 min. in my program.
I would like to dispalay a timer in my StatusBar that will show the current
time of execution during this execution.
Can I do it? How? (Can somebody show a code)
by Chris Petche » Mon, 02 Apr 2001 20:56:17
I just answered this in one of the other newsgroups you multiposted to.
Dont multipost (post the same question individually to more than one
newsgroup) as the answer I put in the other newsgroup doesnt show up here!
It is a quality answer to, EIISSM
Quote:> The execution of :
> Connection.Execute SQL_String
> sometimes takes more than 5 min. in my program.
> I would like to dispalay a timer in my StatusBar that will show the
current
> time of execution during this execution.
> Can I do it? How? (Can somebody show a code)
1. CURRENT execution time of Running jobs in SQL7.0
To anyone,
I am trying to find out how to retreive
the time of which a currently 'Executing'
scheduled job has been running. I have
checked all the different tables and such
that I can imagine and think of. I cannot
seem to come up with a concrete method
of determing this.
ThanX,
PauL
2. SQL Fields with same field called twice
3. TSQL for current job status + time of execution
5. SQLServer Agent - execution of CmdExec Jobs - execution error when owner<>sa
6. problem creating database on NT4 (sp6)
7. Maximum time execution time error
8. Advice needed, PLS-00306 error
9. [Repost: Error during DTS package execution]
10. MMC crash during DTS package execution
11. Strange Error during a MDX select execution
12. The query processor encountered an unexpected error during execution
13. Minimizing CPU usage during large stored procedure execution