Hi Everyone,

I ended up figuring out a workaround myself. If anyone else needs to do this, add an insert trigger to msdb.dbo.sysjobhistory and write a script to use sp_send_dbmail...

That's what I feared.  Thanks for the confirmation.

I am pinging by FQDN...

ODBC looks fine.  It's weird .. because I can connect to other servers.

It sounds to me like you may not be using an identity as a primary key. If so, you need to use identity range management to ensure prevent this...

Hi Andrew,

You can set up a schedule for your snapshot agent when you create a new publication. When the snapshot agent screen appears, check the box, "schedule the snapshot...

Thanks Steve.  I'll give that a try.

Brent

Thanks Robert.  I'll give that a try.  I know that scalability is an issue although I am quite sure we we only need two servers for this task.  Thanks again.

Brent