28 lines
959 B
YAML
28 lines
959 B
YAML
---
|
|
- name: Send notification message via Slack
|
|
delegate_to: localhost
|
|
community.general.slack:
|
|
token: "{{ slack_token }}"
|
|
msg: Running XU_Reindex and XU_ResetHandleIdentity on {{ inventory_hostname }}
|
|
|
|
- name: Execute SQL commands on the TravelCardDynamicsAX database
|
|
ansible.windows.win_shell: |
|
|
Import-Module SqlServer
|
|
$server = "{{ inventory_hostname }}"
|
|
$database = "TravelCardDynamicsAX"
|
|
$query1 = "exec XU_Reindex"
|
|
$query2 = "exec XU_ResetHandleIdentity"
|
|
|
|
Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query1
|
|
Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query2
|
|
register: sql_result
|
|
tags:
|
|
- sql_commands
|
|
delegate_to: "{{ groups['SQL'][0] }}"
|
|
|
|
- name: Send notification message via Slack
|
|
delegate_to: localhost
|
|
community.general.slack:
|
|
token: "{{ slack_token }}"
|
|
msg: Done running XU_Reindex and XU_ResetHandleIdentity on {{ inventory_hostname }}
|