I want to schedule once a week to execute a stored procedure - custom query - in MS SQL. By using the Schedule by Zapier, after adding the MS SQL, it only gives option for inserting lines, but not for executing a procedure.
What is the easiest way for doing that?
Best answer by nicksimard
Hi
I checked our feature requests for MS SQL and found with the following description:
Customer would like to be able to return rows using a custom SQL query with line item support (so they can write all those returned rows to a Google Sheet).
Is that what you’re looking to do (not necessarily the Google Sheets part, but the rest of it)?
+11Hi
I checked our feature requests for MS SQL and found with the following description:
Customer would like to be able to return rows using a custom SQL query with line item support (so they can write all those returned rows to a Google Sheet).
Is that what you’re looking to do (not necessarily the Google Sheets part, but the rest of it)?
Hi @nicksimard. Yes, pretty much. That means we'll have to use a third-party scheduler outside zapier and then start the zap with a MS SQL. It will only find new roles at the specific date that we setup at the third-party scheduler. Hope they speed up this improvement.
Thank you.
+11Hi
I’ve added your vote to that feature request :) You’ll be notified via email if/when that gets implemented. I can’t provide any sort of timeline, I’m afraid.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
