hi; thx for your input. It's checking for another JOB. So this JOB checks for another JOB and determine if it failed a number of times and send email from...

Good job, very well written and demonstrated. Awesome!

Do you have something for connecting to a remote sever and downloading files? I think that's the next thing you should add to...

Hello,

Has there been a revision to add and/or flag if it's a business day e.g. Y or N. This equates not holidays and weekends, preferably in the US. Please send...

I'm not that familiar with functions is there a way to do this with SQL? Here's what i revise from your example.

select mycol, LEFT( mycol+ REPLICATE( '0', 6), 6)+STUFF( STUFF(...