803
I need a program do to the following:
Crawl through a table and if field y = today's date, then clone that record. We have the cloning function all set up, but I am not sure how to have an automatic background process run at say, midnight every night? Javascript, custom workflow, and plugins all have to be triggered by some manual event, such as a button or field change, correct?
Any thoughts?
*This post is locked for comments
Hi Ben T,
You can achieve this by creating an SQL Server Integration Services (SSIS) package that only retrieves the record(s) on a table if field y = today's date and then clones the record(s). You could then schedule the SSIS package to run at midnight every night using a SQL Server Agent Job from SQL Server Management Studio (SSMS).
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
dkrishna
6
Share
Report
All responses (
Answers (
