Skip to main content
To homepage To homepage

Orchestration

Orchestration

  • 2 Topics
  • 4 Replies
2 Topics
G
Starter
gdlc_esculineStarter
asked in Orchestration
Orchestration: questions about custom SQL in schedule groups

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!

321
G
Community Manager
darrirafn
Starter
darrirafnStarter
asked in Orchestration
Power BI Refresh Package in TimeXtender Orchestration

Hello.We are working on adding PBI datasets to the Orchestration process. I have followed these instructions and up until no. 3 in the Power BI part, everything has been a success. However, I’m supposed to choose Orchestration > Packages, select New > Power Bi Refresh. But Power BI Refresh is not an option:  Is there a particular reason for this? I have added Power BI Refresh to the workspace (as a member currently, does it have to be an admin? That is not specified in the instructions at least.)I’m on TimeXtender Data Governance version 24.3.0.87Best regards.   

312
rvgfox
Problem Solver

Badge winners

  • Certified Solutions Architect
    hay71has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings