Skip to main content
Best answer

How to schedule to execute a custom query

  • February 23, 2023
  • 3 replies
  • 284 views

Bruncher

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 nicksimardBest answer by nicksimard

Hi @Bruncher!

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

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • Answer
  • February 24, 2023

Hi @Bruncher!

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


Bruncher
  • Author
  • Beginner
  • 1 reply
  • February 24, 2023

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.


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • February 25, 2023

Hi @Bruncher!

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.