How to schedule a job every alternate Friday?
I think that's not possible with the Matillion scheduler.
You could schedule your Orchestration Job to run every Friday and then use a combination of "Query to scalar" and "If" components to fetch the current week number from your database and then distinguish between even and odd week numbers. For example, the If component could allow the job to continue on even weeks only and the "else" path will end the job on odd week numbers.
Thank you Michael. I followed the same method but have done using a python script.
Thanks for your feedback. I'm happy to hear that you found a solution!