Thank you for the steps. I will follow them first on secondary location, then after failover I will repeat them on primary location.

The only thing missing here is when do...

Yes that was it, I'm always so careless. Thank you for your question that gave me an answer. I've implemented more schedules into each of those 3 LS jobs, I'll...

First I changed the schedules in existing 3 jobs to be active between working hours then I I re-scripted the jobs and in the newly scripted jobs changed the schedules...

Thank you for a to the point reply. I was kind of hoping...

@shane I didn't think of that, thank you very much for your help!

Shane you're right.
What I need to do is check @hierarchyflag for each row (for each profile) and for some reason I keep getting the @hierarchyflag value of the...

Thank you once again for your help. I went with creating 2 separate procedures, it does the job.

How did I miss that with all the reading about cursors... Thank you very much for the essential info about cursors.
Is there an elegant solution or do I have...

I didn't understand the error message correctly so I didn't know that I am searching for an actual XXX string. I thought that meant something else, like ***. So I...

I can change it and I think sooner or later I will have to change it but I'm new at this job, it would take me a really long time....