login about faq

I am trying to schedule a scpg3 batch file that runs fine when run manually. Scheduling tool is SQL server. batch file looks like this; scpg3 user@remoteserver:program/ftp/filename.txt E:destloc

This works 100% when run manually from command prompt, using a passphrase-less key, but when scheduled to run under the same credentials produces error 'Could not connect to broker'

help!

asked Jun 10 '11 at 13:58

guntere's gravatar image

guntere
1111


Hi Guntere,

Under what user account is the SQL job running as? If it's running as the SYSTEM account it might be failing because the SYSTEM account is unable to start Tectia Broker. That is not currently supported.

One alternative is to configure your SQL job to run as a regular user account. I'm not that familiar with SQL Server scheduling so I don't know if it supports running scripts under specific Windows user accounts. If not, you might be able to get around this using "runas" or some other third party tool that allows you start a process as another user.

link

answered Jun 15 '11 at 15:41

Roman's gravatar image

Roman ♦♦
7735817

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16
×12
×1

Asked: Jun 10 '11 at 13:58

Seen: 3,982 times

Last updated: Jun 15 '11 at 15:41

All user contributed content licensed under the cc-by-sa license.
Powered by OSQA.