I haven't worked with the connect agent, so this might not apply to the
script that you are
trying to run, but the ADSM scheduler is designed to run ADSM commands,
and doesn't work
with other system scripts or batch file. You might try running the sql
script from window AT
scheduler.

Malkit Hayun wrote:
>
> Hi,
>
> I have installed the ADSMConnect agent for SQL server, and tried to
> create a schedule to run automaticly the SQL server backups.
> Since the Nt I'm working on is being backed up it self - I installed the
> scheduler program twice as a service - One for the NT machine and the
> second for the SQL server.
> I created a script that contains 'sqldsmc' commands for backing up.
> When I am tring to run that script from the command line - The SQL
> Server is being backed up pefectly! However - when I try to run this
> script from the schedule I created ( In the ADSM Admin GUI) - it allways
> ends with the status of - FAILED - meaning , as I comprehend it, that
> ADSM wasn't able to run that script.
>
> What should I do about it???
>
> Thank You,
> --
>
>     *--*--*--*--*--*--*--*--*--*--*--*--*--*
>
>           Malkit Hayun
>           Application Engineer
>           UDI - Unique Data International Ltd.
>           ISRAEL
>
>           E-mail:       malkit AT udi.co DOT il
>
>           Voice:        +972-3-9512064
>           Fax:          +972-3-9512065
>     Mobile:       +972-50-611050
>
>     *--*--*--*--*--*--*--*--*--*--*--*--*--*