EnqueueExportJob
Puts an export job in queue and starts the job when computing resources become available.
Execute
Sample EXECUTE EnqueueExportJob Table='Leads', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE EnqueueExportJob Table='CustomObject_cdata', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE EnqueueExportJob Table='Activities', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE EnqueueExportJob Table='Activities_NewLead', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE EnqueueExportJob Table='ProgramMembers', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
Input
Name | Type | Required | Description |
Id | String | True | The id of the export job. |
Table | String | True | The table to export. Only certain tables support bulk exports, including: Activities, Leads, ProgramMembers and any custom object. |
PollingInterval | Integer | False | In case the job queue is full Marketo will throw an error. We will keep trying to enqueue the job until the queue is freed. This value specifies the time in milliseconds between each poll. Set to -1 to simply throw the error instead of retrying. If not specified the value provided in the connection string will be used. See JobPollingInterval connection property for more information and the default value. |
Result Set Columns
Name | Type | Description |
Id | String | The Id of the export job. |
Status | String | The status of the export process. |
Format | String | The format of the export job. |
CreatedAt | Datetime | The date when the export job was created. |
QueuedAt | Datetime | The date when the export job was queued. |
Success | Boolean | Boolean indicating if the procedure was executed successfully. If false, the output parameter 'Details' will contain the failure details. |
Details | String | Details of execution failure. NULL if success=true. |