Urgent Help needed regarding Schedule Task

[Jeswanth]

Hi every one,

I have a stored procedure which activates a task when ever that sp is called.
and this procedure gets out of the loop.

the task get started running.

Is there any way in Sql server that the same stored procedures should wait until the Task finishes and return a code either 1 or 0 for success or faliure of the task.

Help is greatly appericated
Jeswnath

[patrick fediere]

Hi Jeswanth,
I got the same and the only way i found was of updating a specific row in a table, giving the status about the Sp.
when the sp start first the sp update the row to "start"
etc. "Running" "stop"
If the same sp try to be started when an other instance is running, it waits for delay and try later.
Bye



On 12/22/98 12:26:12 PM, Jeswanth wrote:
> Hi every one,

I have a stored procedure which activates a task when ever
> that sp is called.
and this procedure gets out of the loop.

the task
> get started running.

Is there any way in Sql server that the same stored
> procedures should wait until the Task finishes and return a code either 1
> or 0 for success or faliure of the task.

Help is greatly appericated
Jeswnath