I found some links, but most of them are incomplete and don't seem relevant.

Do I need to open a case with Microsoft. Also, just to add, failover was done by...

But when you look at the size of the log, it is so small that it is negligible. I am not sure how even 10% growth option would have an...

Did you add a new step for the job with xp_sendmail and the required parameters. i.e when the job fails it would go that step and execute the same.

Are you referring to SQL server 2000 or SQL server 2005.

If you are using SQL server 2005, I would suggest you to use database mail feature instead which is lot...

SQL Server Configuration Manager is showing as LOCAL

I am trying to run it from the server where the SQL server is running.

I have box level access.

When I give like this

exec SQL2005.msdb.dbo.sp_send_dbmail

@profile_name = 'Sample',

@recipients=abc@abc.com', ...

How to configure this if we are using the other xp

xp_smtp_sendmail

I am not able to generate the full report...the report of nightly jobs

Nic,

I am trying to set up job failure notifications and using some scripts.

There I would like to mark the job name as bold in my email message.

I was wondering if...

Thank you all for your support

I was able run this notification successfuly from my job. I tested now.

sp_send_dbmail @profile_name = 'Sample'

, @recipients = 'abc.com'

, @copy_recipients = 'xyz.com'

, @subject = 'Job Test_backup_job has failed'

, @body =...

I am trying to modify the instructions accordingly.

sp_send_dbmail @profile_name = 'Sample'

, @recipients = 'abc@xyz.com'

,...

Please advice, how would I use UNC path? Should I create it or it could be identified if it exists?

The owner of this job is the sql server agent service account.

However, the T drive is being accessed remotely. It is not local drive.

I don't have box level access on...

Using sp_send_dbmail to send notifications is a good option.

But when I trying to attach an attachment I am getting this error message.

Failed to open attachment file 'T:\master\test_backup_job.txt'. Executing API...