Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using SQL jobs - passing parameter etc.

Status
Not open for further replies.
DarwinIT

DarwinIT

Programmer
Apr 25, 2008
142
US
Can multiple instances of the same SQL agent job run concurrently?
If so, is it possible to pass in a parameter in the sp_start_job routine so I could fire up the job multiple times with different results?
 
Sort by date Sort by votes
No, a single job can not be run more than once at a time.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
232
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
337
pjw001
pjw001
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
362
Volvere
V
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
205
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
254
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top