Job skips certain queries?

[Steve]

Has this happened to anyone else?

I have a large job and all the queries run fine when used
individually, but in the job, SQL says completed with success but in
two cases the queries did not run. One of them is even ridiculously
simple: DROP TABLE tblMyTable, etc.

[Erland Sommarskog]

Re: Job skips certain queries?

Steve (go2toa@hotmail .com) writes:[color=blue]
> Has this happened to anyone else?
>
> I have a large job and all the queries run fine when used
> individually, but in the job, SQL says completed with success but in
> two cases the queries did not run. One of them is even ridiculously
> simple: DROP TABLE tblMyTable, etc.[/color]

Are these individual job steps, or are the part of a larger batch?
It is quite difficult to give any assistance with that minimum of
information.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp