Posted by serge on 06/07/05 03:57
See if it might be some type of permission related problem.
I have an SQL 2000 Server which was handle to me today out of the blue
and i was told that it has the following problem:
The SQL Server has several jobs that get executed in regular intervals
to extract data (to a text file) and send them to a specific directory.
It has been seen that as of May 30th, these jobs, although they seem to
complete OK, they do not actually produce the expected output files.
We have executed the jobs manually, and again the files are not
created. We have executed the DTS packages associated with the jobs
manually, and the files WERE CREATED.
This problem is causing issues in production.
ΐny ideas what might be causing this strange behaviour?
[Back to original message]
|