Hi Lowell,

Thanks for the post, your code works great, could you please explain to me what the (STATUS & 512) does and how it works...

For instance I made a test...

I saw that on the website but what I am asking is how do you convert what is in the status field to an actual status?  I mean the number...

Thanks for the info...and don't worry about it.  It is something that is minor, just have to work around it and usually only let it burn you once

For the sake of conversation...I will pose the question to my boss when he returns on Monday...and give him the examples listed as an arguement (not literally)...

He usually has some...

thanks for the info Greg, I wasn't aware of that stored proc...mental note made !

Well I am glad that it isn't just me...I was getting so irritated  

Excellent point made...I will ask my boss as to his reasoning.  In the past everytime something like this he has always had a good reason.  I will mention your senerios...

ok first things first...if you have the ability to modify system tables...go into msdb and find out who the id is that owns the dts

then you can update that row...

I didn't even realize I spelled it incorrectly...thanks for pointing that out....

The jobs are running on a schedule so any job that kicks off during the window of 1 to...

you need to go into query analyzer and into help to the about portion and see what version of QA you have.

then go on the server in question via QA...

PERFECT...thanks for the info...

OK You are the man...I had to make one slight modification but after reviewing your logic it makes total sense and I love  it...way to go man...

My changes are in...

Can you put SELECT statements inside that COALACSE statement???

I don't think you can but this is what I would love to have, it would evaluate the first select statement, if...

Thanks for the code but it did not work...it basically returned the same value...

For what ever reason my boss does not seem like he wants to have me use a...

I am working with this at the moment, I will let you know what come of it...quickly