• 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

    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.

  • $organization in reply to Former Member

    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.

Reply Children
No Data