How to create a crawler program in Dynamics?

(0) Share

Report

Posted on by Ben T

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (1)

Report

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).

Was this reply helpful? Yes No