So have you ever had one of THOSE days?
So I’m finishing up building a shiney new SQL Server 2005 Instance and I start configuring Database Mail. Everything is going fine and once it’s setup I do a “Send Test Email”. I get the email in a couple seconds so for my final test I create a dummy job (Select getdate() or something like that) and on the notifications tab I set it to email me when the job completes.
I kick off my job… nothing… weird. I try again… nothing.
It’s getting later in the day so I figured that I fat-fingered the setup… so I go through and do it again… same test and same results.
Sadly enough it took me 2 Database Mail reconfigures before I remembered that in order for the SQL Server Agent to use Database Mail that it needs to be configured to do so.
UPDATE: I forgot to mention that restarting the SQL Server Agent Service is required before the changes take effect. Thanks Eric!!!
*sigh* 
Time to step away from the keyboard for a while LOL… is it 5:00 yet? I’m sure it is SOMEWHERE!! 
Enjoy!!
Yesterday I was attaching a database but SQL Server is throwing out an error (compression issue). I asked for help at twitter, and the tweeps sent me to various online resources (I focused on Paul Randal’s blog). Research, read, Research, read…test…research…read…test…I was running out of clues!
Then I came across a forum post that suggests I check the data file’s properties and see if it is marked “Compress contents to save disk space” (I unticked it). That solved the issue. I ran DBCC CHECKDB and the database was ok! Talking about overlooking…
I’d like to add that once SQL Server Agent is configured, the Agent service needs to be restarted for the change to take effect.
Yup good call Eric
I had to reboot my server for other patches, etc so I didn’t even think about the cycling of the SQL Server Agent. Good Catch!!
Thanks
I setup Database Mail a couple weeks ago, and got it working OK. This week i forgot about the SQL Server Agent restart and this page totally helped me out!