October 16, 2008 at 1:12 pm
SQL Agent account is domain\account
Well the network guys said they checked DNS just now and viola the email just fired on its own i had given up for the day I saw the 3 pm one come in and was noway it working now what changed.
Gosh i see what happens at 4 pm. I don't get it nothing changed on my end and all of sudden it fires.
I am not understanding the logic here..........is it DNS or SQL
October 16, 2008 at 1:31 pm
If unsent on my end i guess it not left to go to SMTP server ? or would there still be some kind of errors on the SMTP ....
October 16, 2008 at 1:54 pm
Thinking over here - job fires email - then i take it at this stage it sends packet to SMTP and some kind of acknowlegement and then handshakes (forgive the lame terms).
If guess if it cannot handshake it then puts the unsent into the queue.
So is there a way to capture the initial output to the smtp server - i guess this is packet sniffing or write a telnet test and append to procedure to try and identify where it fails over
Kind of in dark playing a guessing game but would like to know for sure.
Just a thought.....
October 16, 2008 at 2:04 pm
We don;t have any of the mailroot bits that would easy to figure out cause i see the mail in the badmail queue - what we have is mail relay so no SMTP service or IIS setup ...
So im assuming it just uses the 25 port.....
Wish i was network guru but i don't take no for a reason i want my mail to fire not in piece mail or some days it works ....
I get there - this is fun part investigating.
October 16, 2008 at 2:15 pm
yes exchange server .....
October 28, 2008 at 1:43 pm
So if anyone is watching this thread put in MS call but after a week of just looking around nothing could be found...then viola it starts working - all jobs were hanging, emails were not firing, nothing could be ran from a job. Now without any changes it all works.
Don't you love these problems that just magically work on their own and after i paid for a MS call and got no fix .
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply