How would that help???
Scheduling an agent job has nothing to do with concurrent processes, it only
starts a job!
The original author is looking for a way to start several instances of a
stored procedure concurrently and the best solution for that is DTS. It will
take some work tho, because I am guessing that in order to have your process
work for a given contract, you have to pass the contract ID in some way.
Still it is doable as long as you know the metrics up front.
John
-----Original Message-----
From: Entena Raymond
[mailto:mssqldba-ezmlmshield-x78106217.[Email address protected]
Sent: Friday, October 29, 2004 5:49 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
or maybe you can create an SQL server agent job and schedule it in the
time that you need them to run.
-----Original Message-----
From: Vonesh John
[mailto:mssqldba-ezmlmshield-x61344429.[Email address protected]
Sent: Thursday, October 28, 2004 10:01 PM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
Kanwar,
No, you cannot execute concurrent processes within a stored procedure.
But SQL Server does have a solution to your problem, DTS.
Build a package that has as many concurrent tasks as you need and have
each
task execute your stored proc.
John
-----Original Message-----
From: Singh Kanwar
[mailto:mssqldba-ezmlmshield-x34974712.[Email address protected]
Sent: Thursday, October 28, 2004 9:53 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
My process takes a long time to run and needs to be run for every
contract and can be run at the same time using diff query analyzer
window at the same time, I was thinking of automating this within the
same proc.
Kanwar
-----Original Message-----
From: Pollock Kirsty
[mailto:mssqldba-ezmlmshield-x16411753.[Email address protected]
Sent: Thursday, October 28, 2004 7:31 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
What do you mean by this?
Do you mean you want to execute 2 queries asynchronously from with the
same sp?
I curious as to why.
Kirsty
> -----Original Message-----
> From: Singh Kanwar
> [mailto:mssqldba-ezmlmshield-x10766619.[Email address protected]
> Sent: 28 October 2004 05:19
> To: LazyDBA Discussion
> Subject: parallel execution of query
>
> Hi All,
>
> I need to run more than one query at the same time within
> same stored proc.
>
> Thanks in advance
>
> Kanwar
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page