Thanks for the response.
I ran this procedure in cursor so that i can generate reports for all the records in result set of the cursor.
and the time delay is different for every record.For some records its taking less time and for some records its take more time.
So the time delay code "WaitFor Dealy '00:00:02'" causing a problem. If i put small delay its giving error message
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: Request to run job C5E96594-9876-42FE-9324-5F6DF8F5CC0B (from User Narayana) refused because the job already has a pending request from User Narayana.
I dont want to put more delay for small reports which takes vary less time.
How could i resolve this problem
Please help me in this issue