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!

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

scheduling jobs

Status
Not open for further replies.

junkmail

Programmer
Jan 7, 2001
134
US
I have set up a schedule for a stored procedure to email a group three times a day which works fine but the only problem is it sends the email twice 1 minute apart for each scheduled time. Any thoughts on what might cause this to happen?
 
Check the Retries field in the properties of that job step. It may be that the sproc returns an error the first time it's run.

Does it run normally if you execute it manually?
 
Yes, if I run it manaully everything works fine. I think I narrowed it down to how our email is setup. We have two domains and some forwarding go on(not my expertise) and it appears that some of the emails do not make it to the recipient but still the job does not show an error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top