I do take all the points about access 95 - it's one of those legacy systems that has been allowed to live on long, long past its sell-by date. ...

Anyone come up with any ideas on this one? I'm having to restart the SQL service 3/4 times a day at the moment to get the jobs running again.

I...

I think I might go the reinstall route then. The server is not yet in production so this isn't a problem. Just a bit of a pain as...

I managed to resolved this. Needed to make the profiles public by using:

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

@principal_name = 'public',

@profile_name = 'Student Service Team',

...