Boyito
19th January 2007 15:49 UTC

Verify SQL Server Agent is runnig
How can I do that?
TIA

iceman_k
19th January 2007 19:00 UTC

If you know the executable name, you can use the FindProc plugin to see if it is running. The FindProc plugin can be found on the NSIS Wiki.

Boyito
19th January 2007 19:15 UTC

Yes I know the name
Thnks for the answer

Boyito
19th January 2007 19:34 UTC

Hi iceman
Ive download the plugin, copy FindProcDLL.dll in NSIS plugins directory and call the function with this syntax

FindProcDLL::FindProc "sqlagent.exe"
messagebox mb_ok 'SQL Agent Server Status $R0'

But $RO returns to me 0

But if i write
FindProcDLL::FindProc "sqlservr.exe"
$R0 returns 1

Both services are running, look in my attach image
Could yo help me?

Boyito
22nd January 2007 14:58 UTC

Iceman ??
Are you there??
Could you help me??

Thanks

fishweasel
23rd January 2007 11:30 UTC

That image looks like a snippet of task manager. The SQL agent you are looking for is a service.

You can get the name from running services.msc or typing "net start" on a command line.

The service name you are looking for (if its part of MSDE) is "SQLSERVERAGENT"

i use a batch file to start my service (wether it is running or not) and then a reg entry to make it run automatically from then on :

Batch file :

net start "SQLSERVERAGENT"

Boyito
23rd January 2007 14:07 UTC

HI fishweasel
Yes the image is part of the task manager
The service i want to detect is SQL SERVER AGENT and in this view is "sqlagent.exe".
I dont need to start o set it automatically only i need to detect the status of this particullary service

Boyito
25th January 2007 14:58 UTC

Ive found something

If i run the installer in W2003 still the problem, but if i run the same installer in W2000 works fine.
Maybe FindProcDLL::FindProc not work in w2003 environment??