Hi,
I'm creating a stored procedure that will be triggered by a 'Scheduled Task' in HFCS. For doing so, you need to use hdeclareexternal for all files used and define the connection. However, in order to be able to run on different HFCS servers I would liek to test the name of the HFCS server the stored procedure is triggered in. Is there a way to know the name of the current server on which the stored procedure is running so I can dynamically define the connection in hdeclareexternal for the files used?
Thanks,
Peter