Posted by Erland Sommarskog on 05/07/07 21:49

Connie (csawyer@rwbaird.com) writes:
> I have a query that takes blobs that have been created within the last
> day out of sql server and places them on a disk drive. The query is a
> stored proc which runs in a DTS job. The job shows failure when there
> are no pdf's created in the last day, how do I correct this??
> Here is my stored proc code:

Yeah, we've seen your stored procedure a couple of times now. :-) But
what about the error message? Does the procedure produce an error? Don't
you get that later on when you try to move the stuff?

Anyway, post the error message and the code that produces it. Then you
may get more than guesses in return.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Query help: Item below reorder level-find all items for same vendor
• Prev in forum: Re: Query help: Item below reorder level-find all items for same vendor
• Thread view: Re: Fix Failure result due to no records found

[Reply to this message]