This will start the maintenance plan and monitor for the job completion.

Declare @JobStatus int

Declare @JobID nvarchar(150)

Declare @PlanID nvarchar(150)

--This is the Job you want to start

Set @JobID = '####' --Job...

All that is secondary. Really it comes down to:

1. I have a maintenance plan job

2. I want to start that job in another job

3. I do not want to...

I know the index job takes 14 minutes to run; but when started from another job it takes 0 seconds (per the history).

I want to index the tables I am loading data into before they are used later in the job. When i run the maintenance plan as a step in...