Bookmark Topic Watch Topic
  • New Topic

Automated process to truncate a table

 
Praveen RajKumar
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

We have a table where we keep track of recent transactions.
Whenever the no.of records count reaches 10000 we truncate the table.

Till now we are doing this process manually.
Is there any automated process to write a procedure and schedule it to complete this activity.

thanks
Praveen
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please do not create multiple topics for the same question. Please continue discussion in your other thread here http://www.coderanch.com/t/590578/JDBC/databases/Automated-process-truncate-table.
    Bookmark Topic Watch Topic
  • New Topic