Re-Submit the Job

Last Post 28 Sep 2009 09:03 AM by Shafiq. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shafiq
New Member
New Member

--
28 Sep 2009 09:03 AM
Hi,

I have a job which continously run every 2 minutes. Job checks an entry in a table, if there is no entry it just finishes, but if there is an entry it excute a stored proc and then finishes. Near the end of the execution of stored proc, I want to check if there is more entries in my table then re-submit the job. How can I achive this. Currently job finishes and then it re-submit after 2 min. But if a job just took 30 sec. to complete then it will still need to wait 1 min and 30 sec for next re-run.

Thanks
Shafiq
You are not authorized to post a reply.

Acceptable Use Policy