Skip to content
+1-888-319-3663

COMMUNITY FORUM

update SmartConnect Table

Vijay asked 7 years ago
Hi, I have a problem in updating a column NextRunDateTime in ScheduleMaster table of SmartConnect database using SQL Command Task. Actually, I need to postpone the schedule date & time to next day if map fails. So I wrote a SQL Command on map fail task as: UPDATE ScheduleMaster SET NextRunDateTime=CONVERT(char(10), getdate()+1, 126)+' 09:00:00.000' WHERE ScheduleMasterId='<<MyMapIDname>>' It did not get updated if schedule runs automatically as per scheduled. But I run map manually, it updates the record perfectly in table. I would like to know why itself is not updating when map starts as scheduled automatically. Kindly help me out.
patrick replied 7 years ago

Vijay,

thanks for the question.

You had opened a support case for this and we took a look.

We found that the issue is that the tsql script worked fine. But the issue is that after you are Map task runs and updated the ScheduleMaster, then the eOne Scheduler comes behind it and sets it to the next scheduled time overwriting your own.

You were able to get around it by updating it in a different map.

The only solution I can see otherwise is to use a db trigger on the table itself and have it reset the datetime to whatever you need it to be since that would run just after the scheduler set it to the next expected datetime.

Answers
Best Answer
patrick answered 7 years ago
should have marked that as the solution.

If you would like to submit an answer or comment, please sign in to the eOne portal.