Answered by:
BizTalk Schedule Task adapter - To stop the sql receive location in weekends

Question
-
Hi Experts,
I have got an requirement, to stop the sql receivelocation on weekends.
In the SQL receive location we have the polling of 1hour. Including to this we need to stop the polling on weekends.
I have tried with BizTalk schedule task adapter, In that i have a option of weekly schedule, but i dont have the option of polling interval.
Please let me know is there any option to set the scheduling using the BizTalk adapters.
I have an alternative option to do this thro WMI script. But we are looking to do it thro BizTalk adapters. Please suggest.
Regards, Aboorva Raja R Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Thursday, February 2, 2017 1:02 PM
Answers
-
Refer few ideas shared in the links below to disable SQL receive location over the weekends:
1. Using VB Script.
2. Running receive location on dedicated host and disabling host instance using WST over the weekend.
https://social.msdn.microsoft.com/Forums/en-US/6dd3c206-8699-444c-a7f1-f69d3d5c1266/how-to-set-receive-location-to-run-certain-days-and-also-certain-hours-in-a-day?forum=biztalkgeneral
Rachit Sikroria (Microsoft Azure MVP)
- Edited by Rachit Sikroria Thursday, February 2, 2017 1:17 PM
- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 1:15 PM -
Hi Aboorva,
You can try below logic.
I believe you are executing some stored procedure through your sql adapter.So you can check the Day just in beginning in Sproc whether the current day is Sat or Sun , if yes then you can skip to execute the procedure otherwise execute your whole SP.
Regards
Abhay Giri
Mark this as answered or vote , if this help you.- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 6:14 PM -
First of all don't use Sql adapter use the wcf-Sql adapter and then check this blogg post http://mikaelsand.se/how-to-only-poll-data-on-specific-weekdays-using-the-wcf-sql-adapter/
- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 8:23 PM
All replies
-
Refer few ideas shared in the links below to disable SQL receive location over the weekends:
1. Using VB Script.
2. Running receive location on dedicated host and disabling host instance using WST over the weekend.
https://social.msdn.microsoft.com/Forums/en-US/6dd3c206-8699-444c-a7f1-f69d3d5c1266/how-to-set-receive-location-to-run-certain-days-and-also-certain-hours-in-a-day?forum=biztalkgeneral
Rachit Sikroria (Microsoft Azure MVP)
- Edited by Rachit Sikroria Thursday, February 2, 2017 1:17 PM
- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 1:15 PM -
Hi Aboorva,
You can try below logic.
I believe you are executing some stored procedure through your sql adapter.So you can check the Day just in beginning in Sproc whether the current day is Sat or Sun , if yes then you can skip to execute the procedure otherwise execute your whole SP.
Regards
Abhay Giri
Mark this as answered or vote , if this help you.- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 6:14 PM -
First of all don't use Sql adapter use the wcf-Sql adapter and then check this blogg post http://mikaelsand.se/how-to-only-poll-data-on-specific-weekdays-using-the-wcf-sql-adapter/
- Proposed as answer by SMSVikasK Thursday, February 9, 2017 2:40 AM
- Marked as answer by Rachit Sikroria Friday, February 10, 2017 5:20 AM
Thursday, February 2, 2017 8:23 PM