thanks for the reply.

well... i can 'can' do it this way, but

i would have to create, execute the job, then

remove the linked server as we do not presently

allow the...

well... instead of reinventing the wheel up front, i'll

think i'll browse the net for some scripts which will do this.

i'll also deconstruct one of the packages via vb, and see...

yes... it's a real pain, and we are all putting up with it. you could just

use the (ctrl+shft+tab) to scroll between tabs, but that might feel like the

same thing....

cool! you rock bro!

what? with the paren's and all that?

i noticed you have the (in) instead of (=).

does that work?

wow that was simple.

thanks!!

what about xp_cmdshell with jobs?

i understand you can start a job from a different server, but can't

find any good examples.

wow... many thanks!

thats just the information i needed!

you guys rock!

ok good. thats cool.

cool. thanks for the calculation.

thats interesting.

appreciate it.

well not really a spid associated with this i don't think. i'm seeing the value

from this:

select * from sys.dm_os_wait_stats order by [waiting_tasks_count] desc

wait: OLEDB

waiting_tasks_count: 601073801

wait_time_ms: 55886480

max_wait_time_ms: 443610

signal_wait_time_ms: 0

thanks for the reply...

i don't see any thing as a linked server, but i see a bunch of providers.

any ideas would be greatly appreciated.

thanks in advance.

actually... i am running across the same thing. what other way

is there to see which jobs are currently running? besides

looking at Management Studio, or EM of course.

i'm having...

thanks for the reply, but i'm alittle confused on

how this works.

is this what you are saying?

-------------

-------------

create the following files:

C:\servers.txt Contains the server names.

C:\myscript.sql Containts the...