lets see if i can explain this better.

the logic checks a job for it's enabled state.

if i have 4 individual jobs (job1, job2, job3, job4) and

they all must...

yes. this is the logic exactly, but how

do i initiate some thing like the following:

IF @job_name=N'test' = @enabled=0

THEN SET @job_name=N'OtherJob' @enabled=0

ELSE

END

starting & stopping the jobs is no problem,

but...

a real guru once told me that

knowing where to look for the answer to a problem

is equally as important as knowing the answer.

my 2 bits.

it looked like it could have worked out ok,

but i just checked the syntax, and some thing is

missing. since i'm not that familiar with it

i didn't know...

last question...

any ideas on a more complex replace script?

what if you wanted to keep the first set, remove every

thing between, and then include the last set? maybe with...

excellent... thanks!

so... this will only replace the ouput given, and not the actual

values within the table right?

just want to make sure.

also... when you say MyField, do you mean...

Again... many thanks my friend

oops... what about the definition

for Table:

DBA_SERVER

excellent! thanks ramses

Never mind... I found a great explanation here:

http://blogs.msdn.com/rogerwolterblog/archive/2006/02/28/540803.aspx

Cheers

great script!

but it's looking for a table called: BAK_REPORT

don't see it created in here though.

well then so the next question is 'how' does one get the 'report' they created

to execute from within a job AND to output the results in the same format

the report...

ok.. well now i know.

thanks for the post

excellent... thanks!

i love hot-keys.

know any more?? i would be interested to see'em all

if i can.

cheers