Skip to main content
To homepage To homepage
Solved

Orchestration: questions about custom SQL in schedule groups

  • June 3, 2025
  • 1 reply
  • 43 views
G
Starter

Hi, 

I have two questions regarding Orchestration, schedule groups.

(1) There is the option to make a schedule based on a SQL custom script. When I try to test this functionality out with the following statement:

SELECT CAST('2025-06-10 01:00:00' AS DATETIME)

It gives me the following pop-up: 
 

Does someone know why I don't get query result = '10-06-2025 01:00:00’? The SQL statement produces a valid datetime value in SMSS.

(2) I need to schedule a job that runs four times per day for a project. I wanted to build this schedule with the custom SQL option and by using a calendar table in our database from the Prepare Instance. Is this possible?

 

Thanks in advance!

Best answer by gunnarsteinn

Hey

 

  1. I notice that the dateformat is different than outputted. Can you try:  SELECT CAST('10-06-2025 01:00:00' AS DATETIME)
  2. Just so I understand the requirements, would “Repeat every” do the task for you? That is generally simpler and you could for example do “Repeat every 2 hours between 08:00 and 17:00”
    Note that we have some documentation on Custom SQL here:

     

View original
Did this topic help you find an answer to your question?

1 reply

G
Community Manager
  • gunnarsteinn
  • Community Manager
  • 2 replies
  • Answer
  • June 19, 2025

Hey

 

  1. I notice that the dateformat is different than outputted. Can you try:  SELECT CAST('10-06-2025 01:00:00' AS DATETIME)
  2. Just so I understand the requirements, would “Repeat every” do the task for you? That is generally simpler and you could for example do “Repeat every 2 hours between 08:00 and 17:00”
    Note that we have some documentation on Custom SQL here:

     

Christian Hauggaard
1 person likes this
  • Christian Hauggaard
    Christian Hauggaard

Reply


Most helpful members this week

Terms and ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings