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

Status : 

 


1
1
Sign in
to vote
ID 633140 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 12/23/2010 9:06:04 AM
Access Restriction Public

Description

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. 
Sign in to post a comment.
Posted by Alex [MSFT] 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 Alex [MSFT] 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