January 13, 2003 at 7:53 am
IO wonder if anybody has any experience with this.
We have a scheduled job that takes about 1.5 hours to complete. The Job is a C++ program that does a lot of inserts from another database. (on the same server)
If the SQLServerAgent runs under LocalSystem the tool is finished in 1.5 hour. If we run the SQLServerAgent under anotheracount ( Local Administrator) it takes about 2.5 hours........
Unfortunately the job also needs to copy data from a network share so the jo has to run under a Domain User Account.
Does anybody has any Idea why it could make such a difference ???
I looked into profiles etc and there is nothing that could explain the difference....
or is there ?
January 13, 2003 at 10:04 am
I thinks that it has to be with permissions in the operating system
January 13, 2003 at 2:08 pm
You can see a simialar result with the backup command. The time it takes in a maintenance plan is much less than the time it takes in QA. Probably something to do with job priority, Internal sql commands get priority over external sql commands
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply