SQL Server Agent - Allow Multiple instances of single job by RobinRamsey

Active

Type:	Suggestion
ID:	633140
Opened:	12/23/2010 9:06:04 AM
Access Restriction:	Public

Workaround(s)

view

It would be of benefit to have allow one SQL AGENT JOB have multiple instances of it's process. Our internal processing imports data into a central import store. These imports can vary in processing time. Currently the job that does that can only process one import at a time. This leads to backlogs. To get around this I schedule multiple jobs that do the same thing.

Details (expand)

English

Tools (SSMS, Agent, Profiler, etc.)

It would be preferable to have just *ONE* job to maintain and the ability to invoke multiple instances.

Improved Reliability

Improved Administration

Improved Performance

0 attachments

Posted by Microsoft on 1/8/2013 at 2:47 PM

Hello

We took a look at this DCR along with several others. Unfortunately based on current customers votes count we decided not to proceed with this DCR in the next release.
However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this implemented.

Thanks for writing to Microsoft.
Alex Grach (MSFT)

Posted by Microsoft on 12/27/2010 at 12:23 PM

Hello Robin

Thank you for proposing a new DCR for SQL Agent. We are always looking forward for the customer feedback. It is indeed interesting proposal, you may solve it with MSX/TSX solution but it may be to complicated for this case. We will consider your proposal in one of our future releases.

Thank you
Alex Grach

Posted by aaronbertrand on 12/26/2010 at 9:35 PM

I think the workaround you mentioned is more than adequate. Most people don't want their jobs to be able to be spawned multiple times.

Microsoft