Can you try 'ssl://smtp.gmail.com', and port '465'

There are two approach:

one is you can use notification feature of the job to send e-mail notification when job completes i.e. success or failure.

Second is you periodically check the job...

Check the installation file to make sure no file is missing/corrupt. Have you done any successful installation with this installation file.

HTH

One way to track is to create trace with SQL profiler.

HTH

Have you checked the execution plan? Attached the execution plan so people can help you.

Rund the DBCC CHECKDB command to find further information.

Refer following link for the actions to resolve the issue:

http://social.msdn.microsoft.com/Forums/en-US/ea8b251f-fbce-4f8b-8a87-1b570688ce88/suspect-database-recovery-sql-server-2005?forum=sqldatabaseengine

HTH

Interesting question, thanks Carlo.

Thanks and appreciate all your comments!

Are you lookin for following link?

http://sql-format.com/

Why you would like to do that? What you want to achieve?

There are many books available in the market on SSIS and get any book with good rating to start with is a good idea.

Who ever supports in PROD environment experience like "butterflies flying in my stomach" and I guess that would be the BAD DAY!

I am not sure if any relation between Display name and Exchange server?

If above solution won't work. Use latest good backup to restore the database. Make sure in that case you might have data loss. Hope this is not your production server....

What is the name of the database?