How to insert a row in a Microsoft SQL Server table within a Mail & Deploy Task?
FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho
If
a new row should be added to a table in a Microsoft SQL Server Database
when running a Mail & Deploy Task, this can be achieve following
the steps described below.
Create a Microsoft SQL Server Datasource
and then use this Expression in the Action Execute Code:
EvaluateDatasourceExpression("datasource_name", "query" )
The
challenge is to make your SQL Server reachable to the M&D instance
and then set all the permissions to allow to insert a row in a table.
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
How do I configure E-Mail Notifications in Mail & Deploy, when a Task in a Workspace fails?
FIRST CREATED ON 17 May 2023 I AUTHOR Emma Camacho Configuring E-Mail Notifications in Mail & Deploy for task failures ensures that you’re promptly informed of any issues in your workspace. Here’s a quick guide on setting up these notifications to ...How to use the Data Exchange feature in Mail & Deploy?
FIRST CREATED ON 31 May 2023 I AUTHOR Emma Camacho The Data Exchange feature in Mail & Deploy allow the export of the Execution Logs into a database that can then be loaded into a Qlik App: If enabled, Mail & Deploy will write maintenance data (e.g. ...What is Mail & Deploy's Heartbeat, and how does it function?
FIRST CREATED ON 10 Oct 2023 I AUTHOR Emma Camacho With Mail & Deploy's Heartbeat, you can regularly check the system's status and key components, such as data connections, tasks, and processes, to confirm they are functioning as expected. Use a ...How to manually send notifications when a task fails?
FIRST CREATED ON 16 December 2024 I AUTHOR Emma Camacho Sending E-Mail Notifications in Mail & Deploy when a task fails ensures that you’re promptly informed of any issues. Although you can use the automatic E-Mail Notifications in Mail & Deploy (for ...How do I configure Okta for authentication and user management in Mail & Deploy?
FIRST CREATED ON 5 Sep 2023 I AUTHOR Emma Camacho Configuring Okta for authentication and user management in Mail & Deploy streamlines user access and enhances security. Here’s a step-by-step guide to set it up efficiently: 1) In Mail & Deploy ...