• Replies 5 replies
  • Subscribers 332 subscribers
  • Views 151 views
  • Users 0 members are here
Related

Automating Regular List Pulls

Charles Buchanan
$organization

Is anyone out there automating regularly scheduled list pulls and how are you setting it up?  I know it's fairly straightforward to do this if you schedule the execute an output set to run off a dynamic list.  But, how easy it is to do using extractions?  It doesn't seem like there is a way to schedule one extraction to run everyday (over and over again), so do I need to make 365 copies of a daily extraction and schedule all of them one-at-a-time?  I'm also not sure of an easy way to schedule the output set since this runs off the list manager list which isn't created until after the extraction has run.  

Thanks,

Chuck 

Parents
  • Former Member
    Former Member $organization

    I’m also very interested in this.

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Sheila Crossman
    Sent: Wednesday, August 14, 2013 8:47 AM
    To: Cate Ridenour
    Subject: Re: [Tessitura Marketing Forum] Automating Regular List Pulls

     

    I would love some more info on this if you don't mind. I'm somewhat familiar with stored procedures but not the cursor part.

    From: Christine Chester <bounce-christinechester8482@tessituranetwork.com>
    Sent: 4/22/2013 9:42:20 AM

    We're just setting up some regular extractions to take place every night, and I've done the following:

    • Set up the extraction the way you want it in Extraction Manager
    • Save a list with no criteria in List Manager for the results
    • Create a local table to store the extraction ka_no and the list_no pair
    • Create a stored procedure which uses a cursor to run through the local table, executing the extraction and saving the results into the list for each pair.
    • Schedule the stored procedure to run each night 

    If you would like me to share the stored procedure with you, let me know.

    We don't need to export the results out into a file each night, so I don't know how far this will help you.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    I’m also very interested in this.

     

    From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Sheila Crossman
    Sent: Wednesday, August 14, 2013 8:47 AM
    To: Cate Ridenour
    Subject: Re: [Tessitura Marketing Forum] Automating Regular List Pulls

     

    I would love some more info on this if you don't mind. I'm somewhat familiar with stored procedures but not the cursor part.

    From: Christine Chester <bounce-christinechester8482@tessituranetwork.com>
    Sent: 4/22/2013 9:42:20 AM

    We're just setting up some regular extractions to take place every night, and I've done the following:

    • Set up the extraction the way you want it in Extraction Manager
    • Save a list with no criteria in List Manager for the results
    • Create a local table to store the extraction ka_no and the list_no pair
    • Create a stored procedure which uses a cursor to run through the local table, executing the extraction and saving the results into the list for each pair.
    • Schedule the stored procedure to run each night 

    If you would like me to share the stored procedure with you, let me know.

    We don't need to export the results out into a file each night, so I don't know how far this will help you.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data