{
   "jobId":0,
   "jobType":{
      "jtyId":0,
      "jtmId":0,
      "name":"The job type name",
      "source":{
         "srcId":0,
         "name":"Vertica at Staging",
         "extractor":"Vertica:DLX",
         "driver":"com.vertica.jdbc.Driver",
         "url":"jdbc:vertica://tfe-vertica-stg:5433/test",
         "username":"test",
         "password":"test"
      },
      "destination":{
         "destId":0,
         "name":"name",
         "url":"None",
         "username":"",
         "password":"",
         "accessKey":"",
         "secretKey":"",
         "fileNameTemplate":"tapad-${fireTime?date?string(\"yyyy-MM-dd\")}-${desc}.txt",
         "fileType":"TSV"
      },
      "schedule":{
         "schedule":"0 0/1 * 1/1 * ? *"
      },
      "data":{
         "extractionSQL":"\nselect\n  device_id,\n  campaign_id,\n  date,\n  creative_id,\n  campaign_id,\n  device_id,\n  inventory_type,\n  platform_id,\n  sum(impressions) as impressions,\n  sum(clicks) as clicks\nfrom (\nselect\n  device_id as shared_id,\n  campaign_id,\n  date(created_at) as date,\n  creative_id,\n  campaign_id as segment_id,\n  case when action_id = 'impression' then 1 else 0 end as impressions,\n  case when action_id = 'click' then 1 else 0 end as clicks,\n  device_id,\n  1 as inventory_type,\n  platform_id\nfrom taps\nwhere campaign_id = ${campaign_id} and date(created_at) = date('${date}')\n) tt\ngroup by 1, 2, 3, 4, 5, 6, 7, 8 order by date desc;\n    ",
         "additionalData":"{campaign_id=\"1537\",date=\"2013-10-10\"}",
         "template":{
            "header":"campaign_id\tdate\tdevice_id\tcreative_id\tinventory_type\tplatform_id\timpressions\tclicks",
            "footer":"---footer---",
            "row":"${campaign_id}\t${date}\t${device_id}\t${creative_id}\t${inventory_type}\t${platform_id}\t${impressions}\t${clicks}"
         }
      }
   },
   "fireTime":1383196164282,
   "tempFiles":[

   ],
   "status":0,
   "retry":3
}