title: " The job failed" in copying database SQL Server 2012
body: <p>I'm trying to copy a database. When going through the Copy Database Wizard, I'm getting a Execute SQL Server Agent Job error. The error states </p>
  
  <blockquote>
    <p>The job failed. Check the event log on the destination server for details</p>
  </blockquote>
  
  <p>Performing operation</p>
  
  <ul>
  <li><p>Add log for package (Success)</p></li>
  <li><p>Add task for transferring database objects (Success)</p></li>
  <li><p>Create package (Success)</p></li>
  <li><p>Start SQL Server Agent Job (Success)</p></li>
  <li><p>Execute SQL Server Agent Job (Error)</p></li>
  </ul>
  
  <p>Error:</p>
  
  <blockquote>
    <p>The job failed.  Check the event log on the destination server for details. (Copy Database Wizard)</p>
  </blockquote>
  
  <p>I can't seem to find what causing this problem. Am I using the correct approach? I just need to copy this database. Thanks in advance.</p>