Recent pages

Edit
page

New
page

Print
page
Page last modified 09:01, 3 May 2011 by Admin
1
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Data Extract Activity > Extract Types > Tracking Extract > Tracking Extract Output > SendJobs

SendJobs

From $1

    Table of contents
    1. 1. Description
    2. 2. Output Types
    3. 3. Columns
      1. 3.1. ClientID
        1. 3.1.1. Possible Values
        2. 3.1.2. Data Type
        3. 3.1.3. Length
      2. 3.2. SendID
        1. 3.2.1. Data Type
        2. 3.2.2. Length
      3. 3.3. FromName
        1. 3.3.1. Data Type
        2. 3.3.2. Length
      4. 3.4. FromEmail
        1. 3.4.1. Data Type
        2. 3.4.2. Length
      5. 3.5. SchedTime
        1. 3.5.1. Data Type
        2. 3.5.2. Length
      6. 3.6. SentTime
        1. 3.6.1. Data Type
        2. 3.6.2. Length
      7. 3.7. Subject
        1. 3.7.1. Data Type
        2. 3.7.2. Length
      8. 3.8. EmailName
        1. 3.8.1. Data Type
        2. 3.8.2. Length
      9. 3.9. TriggeredSendExternalKey
        1. 3.9.1. Data Type
        2. 3.9.2. Length
      10. 3.10. SendDefinitionExternalKey
        1. 3.10.1. Data Type
        2. 3.10.2. Length
      11. 3.11. JobStatus
        1. 3.11.1. Possible values
        2. 3.11.2. Data Type
        3. 3.11.3. Length
      12. 3.12. PreviewURL
        1. 3.12.1. Data Type
        2. 3.12.2. Length
      13. 3.13. IsMultipart
        1. 3.13.1. Data Type
        2. 3.13.2. Length
      14. 3.14. Additional
        1. 3.14.1. Data Type
        2. 3.14.2. Length
    4. 4. Schema Relationship

    Description

    The SendJobs file represents all sends that have activity logged against them for the timeframe of the extract. This list reflects only jobs that have already processed. Sends scheduled for the future do not appear in this list.

    Output Types

    • CSV
    • TAB

    Columns

    Once the tracking extract process creates a SendJobs table, the only column value that may change is JobStatus. All other data associated with the job is static. JobStatus would only change if the send is processing during the extract and completes at a later date.

    ClientID

    Specifies the ExactTarget account identifier associated with attribute set.

    Possible Values

    -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    SendID

    The ExactTarget identified associated to an email send.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    FromName

    Contains the from name associated with the send.  For On Your Behalf sends, this value is the ChannelMember replacement strings.

    Data Type

    String

    Length

    130

    FromEmail

    Contains the from email address associated with the send.  For On Your Behalf sends, this value is the ChannelMember replacement strings.

    Data Type

    String

    Length

    100

    SchedTime

    Contains the scheduled date and time of the send.

    Data Type

    DateTime

    Length

    Small

    SentTime

    Contains the message delivery date and time to the ExactTarget system.

    Data Type

    DateTime

    Length

    Small

    Subject

    Contains the subject line of the email associated with the send. 

    Data Type

    String

    Length

    200

    EmailName

    Contains the name of the email associated with the send.

    Data Type

    String

    Length

    100

    TriggeredSendExternalKey

    The external key associated to a triggered send definition if the send resulted from a triggered send request.

    Data Type

    String

    Length

    100

    SendDefinitionExternalKey

    The external key associated to the user initiated send definition if the send was initiated via a user initiated send definition.

    Data Type

    String

    Length

    100

    JobStatus

    Current status of the job.

    Possible values

    • Scheduled
    • Sending
    • Complete
    • Stopped
    • Canceled
    • Error
    • Deleted
    • PostSendCallout

    Data Type

    String

    Length

    30

    PreviewURL

    A link to a preview of the email that was sent to the subscriber. This preview does not incorporate personalization.

    Data Type

    String

    Length

    300

    IsMultipart

    Specifies if the email was sent in multipart MIME

    Data Type

    Boolean

    Length

    5

    Additional

    EventID entered at time of send.

    Data Type

    String

    Length

    50

    Schema Relationship

    This page was last updated by Josh Cloud on Tue, 03 May 2011 13:01:20 GMT.

    If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 24205 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (1)
    FileSizeDateAttached by 
     sendjobs_schema.png
    No description
    		25.66 kB09:19, 24 Jun 2009AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin