• Thanks tindog, i've had a quick look for xp_SMTP_sendmail but its looking increasingly likely that this could be the way to go.

    The jobs are mainly just sending the results of SQL Queries to different people around the business or they are notifying people that processes have been completed overnight by the database.

    If I'm honest there are a lot of Windows updates that need to be applied on the server but it is in constant use 7 days a week so its difficult to find a window to do a restart. I was wondering if there could be a bug fix we need to apply.

    I'll try and find the download for xp_SMTP_sendmail and go from there.

    Thanks for your response, any help is appreciated.