Skip to main content

Hi, I have a few sql backups with a SQL AG client, I need to run a post script for them where I put down a file so our monitoring tool can check if the file is there, sow the backup was ok.

But when I go to the properties of the subclient, the ‘pre/post process’ tab is greyed out.

Why is this and can this be enabled.

hello ​@Carol George 

Pre/Post Processes are not supported for SQL Availability Group (AG) for now .,,,,, clients.https://documentation.commvault.com/2024e/expert/agents_that_support_pre_processes_and_post_processes.html
 


Best Regards,
Mohamed Ramadan
Data Protection Specialist


Hi, thnx for the reply, is there another way in commvault to run a script then for AG clients?


hello ​@Carol George 

You can use a workaround by running a PowerShell script with task scheduler to be before or after backup schedule policy .
https://blog.netwrix.com/how-to-automate-powershell-scripts-with-task-scheduler

Best Regards,
Mohamed Ramadan
Data Protection Specialist


ok, but this way there is no interaction with commvault? I have to create a file when the backup was ok?


hello ​@Carol George 

You can use Commvault workflows for this though I must admit, I'm not the best coder myself 😅. However, it might be a good option for you. You could also consider using AI tools to assist with the process. Here's a link to the documentation that might help:
https://documentation.commvault.com/2023e/essential/creating_and_managing_workflows.html

Best Regards,
Mohamed Ramadan
Data Protection Specialist


Reply