Hey, did you ever figure out why you were not getting the logging emails from your maintenance plans?

I have the same problem. I get emails from all of my SQL...

Well your suggestions worked.

After I was going to post the DDL, I noticed an error in the SQL statement.

And as I fixed that, the xp_cmdshell to create the file worked.

So...

Oh, thank you, for helping.

Thanks for helping.

The owner of DB is SA, and yes SA is disabled.

I added the stored proc to the application role as execute permission. The one calling the xp_cmdshell.

I...

Yes, it is configured, value is 1.

I do have all the basics covered.

I know this is an old post. But I am having this exact problem now.

I'm a newly hired DBA at this company and have found one of the SQL...

I was looking for the same script, had a hard drive malfunction(with no backup) and lost my script library. so instead of reinventing the wheel.

anywho... I am getting the error...