I have several jobs set up in SQL 7 that use an external TXT file. The file contains get commands for a FTP server. I have messages in the job history that says the file I am looking for does not exists. The logs on the sending Mainframe and the recieving FTP server say the file is there. It only happens on the weekends sometimes. We have exhausted the what else is going on. Is there a glitch in SQL 7 in this area.
I also notice that the job history space is very limited. I am not getting all of the sequences in the log. Is there a way to increase the log buffer?
Thanks in advance for your help! :-)
Randall L. Johnson