Managing Dialing List

Unanswered Question
Jul 14th, 2009
User Badges:


I need some input on managing the dialing list table (DL_xxxx_xxxx) ie i would like to delete records based on few conditions. But i will be removing the records whose status is 'Pending', meaning not sent to the dialer.

Have anyone tried this out and what are all the implication expected because Cisco outbound user guide clearly states that we should not do any operation in the DL table.

Thanks in advance.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)
mitesh.mishra Wed, 07/15/2009 - 12:05
User Badges:


If you want to remove the the records from dialing list, you need to write a job (write instructions when you want to delete the data) in the database. it will flush your data as per the time you mentioned in the job.

>"'Pending', meaning not sent to the dialer" that i didnt get that, i think pending means dialer will dial that particular record.



mohidsheik Wed, 07/15/2009 - 14:55
User Badges:


Do you mean writting a sql job to remove the contacts records? yes we can do but my question is, will there be any implication if I delete these records directly from the table.

And what I meant "Pending" is the callstatus value called "P" meanins pending record, which are yet to be dialed..

Voiceops SSC Mon, 12/20/2010 - 10:59
User Badges:


     Did you ever figure this out?

What did you end up doing?


Nathan Luk Tue, 12/21/2010 - 22:12
User Badges:
  • Bronze, 100 points or more

I've done this before by deleting rows from the DL_ tables but you need to restart campaign manager in order for it to take effect (shhh don't tell Cisco)

david.macias Wed, 12/22/2010 - 07:08
User Badges:
  • Blue, 1500 points or more


I'm glad someone tried this (other than me) for some reason I envisioned gloom and doom by changing the DL tables.  It is a shame that you have to restart campaign manager though, so for me it doesn't make it a viable option.



This Discussion