You can inspect the DE Agent for SQL Server for any errors in the SQL Server.