If a job is 'running' then the job scheduler will NOT start the next scheduled iteration of that job.

I disagree with the 'correct' answer. In order to make a copy of a database on the same server, you must rename the mdf and ldf files or change their...

Try this:

SET NOCOUNT ON

DECLARE @ServiceExists VARCHAR(255)

CREATE TABLE #services

( service VARCHAR(255) )

-- Retrieve list of services that ARE running

INSERT INTO #services

EXECUTE master..xp_cmdshell 'net start'

-- Clean up...