Didnt Help...still seems to lose connection after being idle...

I done this however the the file is "|" , pipe delimited, how do i accomodate for this?

THANKS A MILLION!! that did it

kool... any idea how i can get the Command column to actually show all the info. i'm assuming the data type cuts it off...

yes however, it scripts them as if i wanted to create it with all the job attributes, thus completly over complicating it...

Seems to do what i needed. Thank you very much!!

Is there is a SP that automatically does this for all SP's on a Particular Server, (EveryDB). with out me having to make a cursor?