title: Missing CDC capture Job when enabling CDC on table in SQL Server
body: <p>My database has CDC enabled and it was working fine on several tables. One day (don't know why) it stopped working: no new change was recorded.</p>
  
  <p>I then proceeded to disable CDC as follows:</p>
  
  <pre><code>exec sys.sp_cdc_disable_db
  </code></pre>
  
  <p>I then re-enabled it as follows:</p>
  
  <pre><code>exec sys.sp_cdc_enable_db
  
  GO
  
  EXEC sys.sp_cdc_enable_table  
      @source_schema = N'dbo'  
    , @source_name = N'resource'  
    , @role_name = NULL  
    , @capture_instance = N'dbo_resource'   
    , @supports_net_changes = 1     
    , @captured_column_list = N'Id,Name,Status'    
  GO 
  </code></pre>
  
  <p>Those commands run fine, but it doesn't solve my problem.</p>
  
  <p>I have checked and see that all tables needed for CDC were created, but browsing the agent job I see only the CLEANUP jobs were created, the CAPTURE jobs are missing.</p>
  
  <p>How can I fix it?</p>