September 30, 2009 at 5:03 am
we create a job to find the disk usage of the servers , the job failed due to Executed as user: NT AUTHORITY\SYSTEM. Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. [SQLSTATE 42000] (Error 4832) OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. [SQLSTATE 42000] (Error 7399) OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.]. [SQLSTATE 01000] (Error 7300) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
can any one suggest hoe to resove this , why this job failed ?
September 30, 2009 at 5:59 am
Not much info to go on here!
However, you could try executing the job as a user you know has rights to the drives you are accessing.
September 30, 2009 at 6:44 am
Take the query out of the job and run it manually using an elevated account that has permissions to where the file is located.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply