Permissions writing files across servers

Question

Permissions writing files across servers

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 1

Could the file be still open? Are both these processes running in SQL Agent?

tschuler-738392 Ten Centuries Points: 1172 More actions · Answer 2

Both the processes are running in SQL agent. My process runs at 12:25am and the other process runs on a different server at 10am. The process that grabs the text file that gets created at 12:25am archives the file so it gets created new every day.

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 3

The file shouldn't be open. Could there be some parallel/multithreading that grabs the file?

Can you get the FileWatcher from Sysinternals and see if the file is open when the second process runs?

tschuler-738392 Ten Centuries Points: 1172 More actions · Answer 4

Thanks for your help, I will find this out and let you know what or if anything has the file open.

tschuler-738392 Ten Centuries Points: 1172 More actions · Answer 5

Thanks for the help on this. The file that is being created is created on a Linux file server that all servers write files too. Something did have the file open at this time, so I moved the job to a later time and now everything is fine. Once again, Thanks for your help.

gobidettullo-5709 Newbie Points: 1 More actions · Answer 6

The writing company is need to be familiar with every nearest and surrounding of the areas for providing quality writing service to their students. Important part of all custom essays writing service is to maintain good writing papers . This is very important part of things should provided by the good and quality services with good processes in writing for all major of students.