Check following things:

1. did see any new entries in msdb.sysmail_allitems ?

2. Check Database Mail log

3. What service pack you have ?

4. What result you got...

These kind of task generally done in off peak hours with the proper intimation to users

put the database in SINGLEUSER mode and then do the alteration

Apart from DTA, did you see the execution plan and found anything which disturbs the performance like table spool/lookup etc ?

i think, you can explicitly map that user with that table.try it

create a proxy account and used that account in job.is that what your are looking for ?

Need a lot of patience to study your SMALL queries. but you can do one thing. put the result( same data ) of above queries on let say two...

if there is Date range then

below should work

CREATE PROCEDURE proc_student

@Start_Date datetime,

@end_date...

i am taking your question other way. just...

Enable DatabaseMail on the SQL Server Agent -> properties -> Alert System (check the checkbox), and then restart SQL Server Agent.

have you tried other option ( SP appraoch ) ?

EXEC msdb.dbo.sp_update_job

@job_name=N'NAme of job',

@enabled=0

and still face the issue, restart sql agent

I didnt understand how redundant logins exists in msdb ? two Sa account is very weird thing.Try exec...

You should have been posted this issue in sql 2008 section to get faster(any) response.

Nice thinking Lynn