Skip to main content

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!

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:

     


Reply