(datepart(m,dob)-1)(datepart(m,dob)-3)(datepart(m,dob)-4)(datepart(m,dob)-5)(datepart(m,dob)-7)(datepart(m,dob)-8) = 0

should work too ....

what could I have done better (or not done bad) to get more responses??? not sure if this would get any responses .. but if it does, it'll be truly...

Anyone at all????

Anyone??? Anyone????

Ok so it does not sound like network alias for the server would have been such a bad idea after all??? in fact, let me ask it another way -...

Thanks again .. that sounds like a good idea -

GSquared,

Thanks much for the quick response! But the reason I was thinking of the scripts-export was currently the backups follow the TRUNCATES .... if they dont, the backups will get...

guess something went wrong with the - second attempt -

image I included

Rudy - truly appreciated! I will be taking a look today and check if I can do something similar in our environment

Thanks .... most of the jobs are executing maintenance plans which are backups or optimization jobs ... some issue truncate table scripts on the database ......

am I doing something...

Thanks all for the overwhelming responses ;)!

I cannot believe that MS SQL does not have a synchronous job execution utility that could run a job and report its completion status...

Thanks greg,

however, it appears that these tables do not get updated till the job does not complete executing (with success or failure) - I need to be able to know...

The pseudo-SQL I posted did not show up correctly - here's what I was suggesting -

select @job_status = (SOME_SYSTEM_PROC) @job_name

also, if this status covers both running and success/failure, that...

No, the target table does not have data - it is empty when the insert into is issued.

I was aware of bcp - and i tested the performance achieved by...

lets assume we get to choose that ..... what are our options???