Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fhtapia
Starting Member
9 Posts |
 Posted - 2005-09-06 : 19:46:14
|
| I have the following sample ActiveX Script Dim filesys, filetxtConst ForReading = 1, ForWriting = 2, ForAppending = 8Set filesys = CreateObject("Scripting.FileSystemObject")Set filetxt = filesys.OpenTextFile("c:\somefile.txt", ForAppending, True)filetxt.WriteLine("Your text goes here.")filetxt.Close SET fileTxt = NothingSET filesys = NothingI can set this to run as a job on a Windows 2000 Standard Server w/ Sql Server 2000 SP4, and it runs as a domain User.If I setup this same job on a Windows 2003 Standard Server w/ Sql Server 2000 SP4, My job never runs, instead it is suspended...This same domain user is an admin user on both servers... has anyone else ran into this issue before?? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-07 : 04:48:24
|
| what user is SQLAgent running as? What about SQL Server? Check both of these in your services control panel. Make sure you are using the same user in your win2k3 environment as you are in your win2k environment.-ec |
 |
|
|
fhtapia
Starting Member
9 Posts |
Posted - 2005-09-07 : 11:54:32
|
| I have a domain user which is an Admin on this server, he runs both the MsSqlServer and the Agent Services. This is the same user on my win2k environment as it was an upgrade from an older server. |
|
|
|
|
|
|
Windows 2003 and Sql Server Agent Jobs = suspended