Post reply

Migrate Control-M jobs to SQL Agent

  • March 1, 2016 at 9:18 am

    #316475

    Hello all!

    I need to migrate all CONTROL-M jobs to SQL Agent and I haven't the faintest clue where to start. I am assuming that I could possibly create a POWERSHELL script that does this but I am not sure.

    Any ideas?

    Thank you all in advance for your continued support! 😀

    Everyone has a plan until they get punched in the mouth. --Mike Tyson

  • March 1, 2016 at 9:49 am

    #1862145

    I'm not really sure how to do it, but you're basically facing the migration from xml files to sql scripts. If you're able to convert the xml into relational data, it shouldn't be that difficult, but certainly the adjustments might be tedious.

    Unless I'm missing something depending on the Control-M version you're using.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • March 1, 2016 at 11:31 am

    #1862177

    Thanks Luis.

    Everyone has a plan until they get punched in the mouth. --Mike Tyson

  • March 2, 2016 at 4:18 am

    #1862344

    You will have to query the control-M XML file and extract the information from the elements for server names, job name, and any sql execution or stored procedure being called.

    Good Luck

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply