Stop Dependent Application Services

[Paolo]

We’re test driving Batch Patch and really liking all of the functionality available. Have a few questions about stopping a remote system service and I apologize if this was answered already in another thread.

Scenario

Patching an MS SQL server (Server A) and created all of the specific actions to stop the services on the SQL server.

1. What are the action steps needed in the job queue to stop a separate application server (Server B) service prior to installing the Windows patches on Server A?

2. Are we supposed to be using the Execute remote process/command? If so, what is the command?

Looking for the best method to stop dependent application services prior to patching the DB server.

Thanks,

Paolo

[doug]

Hi Paolo –

To do what you are wanting to do, you’ll need to use the BatchPatch Multi-Row Queue Sequence. You’ll probably use the advanced option, but depending on your needs you might also just use the basic option. Tutorials for this feature are at the following links:

Basic Multi-Row Queue Sequence Tutorial

Advanced Multi-Row Queue Sequence Tutorial 1

Advanced Multi-Row Queue Sequence Tutorial 2

For stopping and starting services inside of a multi-row queue sequence, you would probably use remote process/command actions that look like this:

NET STOP "DisplayNameOfService"

NET STOP "DNS Client"



NET START "DisplayNameOfService"

NET START "DNS Client"

OR

WMIC SERVICE where caption='DisplayNameOfService' CALL stopservice

WMIC SERVICE where caption='DNS Client' CALL stopservice



WMIC SERVICE where caption='DisplayNameOfService' CALL startservice

WMIC SERVICE where caption='DNS Client' CALL startservice

-Doug

[Paolo]

Thanks Doug. I’ll test that out.

[Author]

Posts