Hi,
This is my first attempt to resolve some problem using Workflows.
I have a default subclient that backup all DBs on Windows SQL using SQL agent.
The attached schedule policy runs full daily at 9 PM and then tlogs every 2 hours.
The problem is that a pre and post script has to be run on the client before every full backup, but not during tlogs backup, so I cannot use the pre/post script tab in the subclient properties.
Is it possible to create a workflow that will monitor this subclient activity and if the CommCell is trying to run the full backup, the workflow will pause it, run the script, wait until is finished and resume the backup, and run the post script at the end, but when is backing up tlogs, will bypass both scripts?
Sorry if I am overcomplicating things, if there is a simpler solution, all welcome to share it :)
Thanks,
Marcin