SQL Agent Problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » SQL Agent Problem

SQL Agent Problem

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Friday, June 27, 2003 12:00 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/sqlagentproblem.asp>http://www.sqlservercentral.com/columnists/awarren/sqlagentproblem.asp

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #13676

ckempste

Posted Wednesday, July 09, 2003 12:48 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

Great article and nice fix. A nasty little error to deal with.

Cheers

Ck

Chris Kempster
www.chriskempster.com
Author of "SQL Server 2k for the Oracle DBA"

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

Post #68603

barwickl

Posted Wednesday, July 09, 2003 1:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 12, 2011 10:17 AM
Points: 128, Visits: 5

I had a similar problem myself where the agent was shown as starting and wouldn't shutdown. Fortunately a reboot solved it.

I still don't know what caused it but sounds like it could well a different message box shown by the agent which disappeared after the reboot.

Nice article - something to think about!

Post #68604

Jonr

Posted Wednesday, July 09, 2003 1:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141, Visits: 61

Andy,
Thank you for sharing that, most useful. Had a very similar problem with an RLL, but with Enterprise Manager/MMC on a test machine. This was very easy to pinpoint, as I caused it myself (!) whilst doing an install of a new piece of software. Problem was that the code relied on SQL-DMO, and I had inadvertently included the SQL Server 7.0 SQL-DMO library in the install package, instead of the SQL Server 2000 DMO library. D'oh.
The installer I was using was InstallShield (no reflection on the product, I think it's great), though accidentally picking the wrong library is I guess something you could easily do with any vendor's installation package. Did exactly the same to fix it as yourself, copied across the RLL from another box and it worked fine. Re-installed the package again and it broke it, so I knew for certain it was the culprit. Re-built the package with the SQL Server 2000 SQL-DMO and re-installed it again, worked this time, no issues. I'd suggest you install the same package you've had problems with on a test box with the same NT/SQL Server version/service pack, and see if it breaks that. Bet it will :)

Looks like the problem you've experienced is with a local language resource file for the ActiveX Scripting Host, guess the package that you installed was doing something related to DTS ? If so, check out :

http://sqldts.com/default.aspx?6,105,225,0,1
and
http://www.linxent.com/articles/DTS%20Package%20Files%20Needed%20for%20VB.htm

There's also a useful note from Microsoft concerning Axscphst.dll which may impact the .rll at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_addf_ax_06er.asp
(note that there's an error in the regsvr32.exe example they give, end of line should read Binn\axscphst.dll...)

Probably an incompatibility between the version of the DTS lib. you're installing from the install package, and the one on the target box that's caused the problems. These problems can be really juicy and very time consuming if you're developing for a large combination of target NT/SQL/service pack environments.

As an aside, I love VMWare (www.vmware.com) as it means that new packages can be tested easily, and the original machine image can be 'rolled back' to an operational state if there are any problems - very cool, saves huge amounts of time, especially if you do any SQL Server related development. Recommended.

Edited by - jonreade on 07/09/2003 02:00:00 AM

Jon

Post #68605

David.Poole

Posted Wednesday, July 09, 2003 8:41 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:16 PM
Points: 2,749, Visits: 1,405

I've had this sort of problem with a number of applications. Message boxes that appear behind modal forms are a good one!

I've also seen it happen when someone has converted an old VB program into a DLL but forgot to take out the error trapping message boxes.

You can also get a problem when a Windows app bombs out and locks a file. In this scenario it is always a good idea to look at Task Manager and see what is going on.

LinkedIn Profile

Post #68606

tcook

Posted Friday, June 03, 2005 7:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 07, 2005 11:37 AM
Points: 130, Visits: 1

I have a similar problem as I changed the pw for the user running the sqlagent service (our network admin left the organization so we had to change the pw's for all domain admin. users) and the service states that it is starting....
I tried starting the sqlagent from the command prompt and get no return and a blank .txt file as output. Nothing in the application log of the event viewer or the SQLAGENT.OUT.
I believe this is related to the mail profile for the user because when I log on to the server as the user who runs the sqlagent service and launch Outlook it hangs as well. Trying to stop the SQL mail service in MMC also hangs.
Any other suggestions?
This is a production server so I can't boot during business hours.
Thanks.

Post #187433

« Prev Topic | Next Topic »

Permissions