MS SQL Server - Suspended Sql Agent Jobs

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Suspended Sql Agent Jobs

fhtapia@gmail.com

2005-09-06, 8:23 pm

I have the following sample ActiveX Script

Dim filesys, filetxt
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Set filesys = CreateObject("Scripting.FileSystemObject")
Set filetxt = filesys.OpenTextFile("c:\somefile.txt", ForAppending,
True)
filetxt.WriteLine("Your text goes here.")
filetxt.Close
SET fileTxt = Nothing
SET filesys = Nothing

I 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??

Sponsored Links