Stop Services

[sakshi]

I am automating some task in which i need to stop all the Oracle services which are running.

I have used

RunWait(@ComSpec & " /c " & 'sc stop "' & $sSvcName1 & '"', "", @SW_HIDE)

but the issue is the service name changes each time .

it is according to the database created but always starts with Oracle keyword.

so i am thinking of stoping all services that start with keyword Oracle.

but dont know how to....

can anyone help Please?

thanks.

[Xenobiologist]

Hi,

one way would be

Using this

ConsoleWrite( _getDOSOutput('sc query') & @CRLF)

Func _getDOSOutput($command)
    Local $text = '', $Pid = Run('"' & @ComSpec & '" /c ' & $command, '', @SW_HIDE, 2 + 4)
    While 1
        $text &= StdoutRead($Pid, False, False)
        If @error Then ExitLoop
        Sleep(10)
    WEnd
    Return $text
EndFunc ;==>_getDOSOutput

to get all runnning service, then using RegExp to get the ones which contain the word Orcale and then using e.g. net stop to stop them

Mega

[sakshi]

thanks i tried it but now i have issue with StringRegExp

if you could tell how to seacrh for services starting with oracle.

thanks anyway.

[Xenobiologist]

No problem, if you post the output of my code posted before.

[sakshi]

here is a screen shot of the output . i have used a msgbox to view output.

http://mbf.me/EBBu

[Fantastic]

Try this excelent UDF, it might solve your problem.

Windows Services UDF from engine

I'm using it on a small launcher and it works great.

Edited May 12, 2010 by Fantastic

[Xenobiologist]

here is a screen shot of the output . i have used a msgbox to view output.

http://mbf.me/EBBu

There is nothing with the word Oracle in the screenshot.