Skip to main content
SUBMITTED

Run custom scripts like execution task

Related products:TimeXtender Data Integration
  • November 1, 2024
  • 2 replies
  • 23 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

I have some stored procedures that I would like to run independently, it would be nice to be able to run them as Execution packages.

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • November 1, 2024

Hi,

while doing this directly is certainly an improvement - this is already possible:

if you create Action Steps for each stored procedure that do: "EXEC <name of stored procedure>” and create a dummy table for each each stored procedure, you will be able to use Advanced > Set pre- and postscripts on your dummy tables to trigger the stored procedure on Execution of the table. You can then put the table in an Execution Package and cause the stored procedure to be run on a schedule.


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Author
  • Problem Solver
  • November 1, 2024

Yes, that it’s the way that I’m using now.