I don't see any reference to the SMTP server. Is what's posted the entire script that you're trying to execute?

Go to http://www.sqldev.net/xp/xpsmtp.htm It's a great freebie and does everything you could ask for, for the price!

xp_smtp_sendmail works great on job. Does anyone know of a way to use it if fatal alerts arise in the SQL log?

Weird. I can't seem to get it to work in the "To:" line but I can in the "CC:". I'll keep trying. Thanks.

Randy,

Do you know how to send to multiple people? I've also e-mailed Gert to see if I can get some help. I've tried the usual separtors (, and

Anyone know of any alternative methods or sources for connecting to DB2 from SSIS?

Perhaps I'm not explaining it correctly. I need two subtotals, from different tables. If I put this in the select, it yields incorrect results. Let me know what I can...

OK. That kind of worked (see modifications below). It's still not returning the sum of [Column 17] as PTO_Sum, it's simply returning the first three fieldws in the main select....

It does. I've googled the error and I'm still sorting through all the hits. Hoping for a quicker answer though!

That seems to have fixed the column 1 issue. Thank you. Now, what about not being able to bind o.portfolio?

Or, within your job, do something like:

IF DATEPART (HOUR, GETDATE()) = 5

EXEC master.dbo.xp_backup_log  

      @database = 'JDE_PRODUCTION'

    , @filename = '\\coldstandby\dumpsAllOther\jdedumps\wdent2\logs\tranFRI_LITE.bak'

    , @init = 1

ELSE

EXEC master.dbo.xp_backup_log  

      @database = 'JDE_PRODUCTION'

   ...

Also, depending on the number of databases, you're potentially going to have a lot of home grown scripts. I have one server with around 60 databases. I run maintenance plans stating...

I agree with ezann, I've never seen default jobs on a SQL install either (at least not on 7.0 or 2000). I do have 3rd party software that, upon installation,...

One of the hits points to a hotfix supplied by MS. Not sure what would've caused this if it had been running fine and no other updates have been installed.

Google it. They are some pretty interesting hits that may lead you in the right direction.