Data Replication 2
Results 1 to 6 of 6

Thread: schedule attunity cloudbeam using power shell

  1. #1
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0

    schedule attunity cloudbeam using power shell

    hi,

    Can attunity cloudbeam for amazon redshift tasks be scheduled using power shell?

    Regards
    Ram

  2. #2
    reza.khan is offline Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by ram View Post
    hi,

    Can attunity cloudbeam for amazon redshift tasks be scheduled using power shell?

    Regards
    Ram
    Hello Ram,

    Thank you for contacting technical support.

    Currently, Attunity Replicate does ship with any PowerShell CMDlets. However, there is a Command Line Interface and a scheduler for starting and stopping tasks.

    If you want to schedule the starting and stopping of tasks by Time and Date, please use the Scheduler option found here:


    1. In the top left corner of Attunity Replicate, click the Drop Down next to the "Tasks" Icon and select Server.
    2. Click on the "Scheduler" Tab and then click on the "Active Jobs" tab.
    3. Click the "New Scheduled Job" button to start the wizard to create a Schedule for Starting or Stopping tasks.


    If you want to use the CLI to trigger the starting and stopping of tasks, please use the following steps:


    1. Open a Windows Command Prompt and CD into the following directory: ~\Program Files\Attunity\Replicate\bin
    2. Use the repctl.exe executable to interact with your replicate tasks (replace "Task1" with the name of your task):


    • To Stop a task - repctl connect; stoptask task1; disconnect;
    • Get Task Status - repctl connect; gettaskstatus task1; disconnect;
    • Start or Resume Task - execute <task name> <option> <flags> where
      • <task name> = Name of your Task
      • <option> = A number that represents the following task Types:
        • 1 = Full Load
        • 2 = CDC (Changed Data Capture)
        • 3 = Full Load and CDC
      • <Flags> = Optional Parameter. Use the value flags = 1 to restart a task.
      • Examples:
        • Resume a Task (Full Load and CDC) - repctl connect; execute task1 3; disconnect;
        • Restart a Task (Full Load and CDC) - repctl connect; execute task1 3 flags=1; disconnect;


    If there are any additional questions, please don't hesitate to contact us.

    Thank you.

    Reza K

  3. #3
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0

    getting below error

    hi,

    I tried to use CLI as mentioned by you, getting below error

    REPCTL initialization - failed to initialize environment (status 22)Status: 22,
    Text: Failed to open the server key file 'C:\Program Files\Attunity\Replicate\da
    ta\mk.dat'.
    Status: 22, Text: Class 'ENCRYPTION_CLASS' failed to initialize.




    Quote Originally Posted by reza.khan View Post
    Hello Ram,

    Thank you for contacting technical support.

    Currently, Attunity Replicate does ship with any PowerShell CMDlets. However, there is a Command Line Interface and a scheduler for starting and stopping tasks.

    If you want to schedule the starting and stopping of tasks by Time and Date, please use the Scheduler option found here:


    1. In the top left corner of Attunity Replicate, click the Drop Down next to the "Tasks" Icon and select Server.
    2. Click on the "Scheduler" Tab and then click on the "Active Jobs" tab.
    3. Click the "New Scheduled Job" button to start the wizard to create a Schedule for Starting or Stopping tasks.


    If you want to use the CLI to trigger the starting and stopping of tasks, please use the following steps:


    1. Open a Windows Command Prompt and CD into the following directory: ~\Program Files\Attunity\Replicate\bin
    2. Use the repctl.exe executable to interact with your replicate tasks (replace "Task1" with the name of your task):


    • To Stop a task - repctl connect; stoptask task1; disconnect;
    • Get Task Status - repctl connect; gettaskstatus task1; disconnect;
    • Start or Resume Task - execute <task name> <option> <flags> where
      • <task name> = Name of your Task
      • <option> = A number that represents the following task Types:
        • 1 = Full Load
        • 2 = CDC (Changed Data Capture)
        • 3 = Full Load and CDC

      • <Flags> = Optional Parameter. Use the value flags = 1 to restart a task.
      • Examples:
        • Resume a Task (Full Load and CDC) - repctl connect; execute task1 3; disconnect;
        • Restart a Task (Full Load and CDC) - repctl connect; execute task1 3 flags=1; disconnect;


    If there are any additional questions, please don't hesitate to contact us.

    Thank you.

    Reza K

  4. #4
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0

    powers hell for attunity cloudbeam

    Hi
    if power shell can be used, can you please provide the documentation or steps to follow?

  5. #5
    reza.khan is offline Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by ram View Post
    hi,

    I tried to use CLI as mentioned by you, getting below error

    REPCTL initialization - failed to initialize environment (status 22)Status: 22,
    Text: Failed to open the server key file 'C:\Program Files\Attunity\Replicate\da
    ta\mk.dat'.
    Status: 22, Text: Class 'ENCRYPTION_CLASS' failed to initialize.
    Hello Ram,

    Thank you for the follow up question.

    Looking at the error message, it seems like your Replicate Data directory has a space in the word data.

    Please try to run your command as follows:

    repctl.exe -d "C:\Program Files\Attunity\Replicate\da ta" connect; stoptask test; disconnect;

    The -d flag allows you to specify the actual directory of the Data directory in your installation.

    Please let me know if that works for you.

    Thank you.

    Reza K

  6. #6
    reza.khan is offline Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by ram View Post
    Hi
    if power shell can be used, can you please provide the documentation or steps to follow?
    Hi Ram,

    As previously mentioned, Replicate does not support any Powershell CMDlets.

    However, you can use the CLI in a batch file and then use Powershell to execute the batch files to start and stop your tasks.

    If there are any additional questions, please don't hesitate to contact us.

    Thank you.

    Reza K.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •