Steve,

Here is something to get you started...
I apologize in advance for any formatting problems.
This is for a "FULL" backup.  For an "INCREMENTAL",
change the "sqldsmc" command.

Del Hoobler
ADSM Agent Development
=======================================================================

@ECHO OFF
rem  ==================================================================
rem   sqlfull.smp sample command file
rem
rem   This file is meant to be executed by the ADSM central scheduler
rem   in response to a defined schedule on the ADSM server.
rem
rem   Complete paths must be given for all file names and non-system
rem   commands.
rem
rem  ==================================================================

rem  ==================================================================
rem   Replace "X:" with the drive where SQL agent is installed.
rem  ==================================================================

set sql_dir=X:\WIN32APP\IBM\ADSM\agentsql

X:

cd %sql_dir%

rem  ==================================================================
rem   2 lines below put a date and time stamp in a log file for you.
rem
rem   Note: you can change "sqlsched.log" to
rem         whatever you prefer in lines below:
rem  ==================================================================
date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log

rem  ==================================================================
rem   Replace "srvrname" with the name of the options file name you
rem   plan to use.
rem
rem   Replace "dbname" with the name of the SQL database to back up.
rem
rem   Note: you can change "sqlsched.log" and "sqlsfull.log"  to
rem         whatever you prefer.
rem  ==================================================================
%sql_dir%\sqldsmc /backupfull:dbname /adsmoptfile:%sql_dir%\srvrname.opt
/logfile:%sql_dir%\sqlsfull.log >> %sql_dir%\sqlsched.log


>> NT SQL Connect Agent Schedule Problem
>>
>> Can anyone provide an example of the schedule command
>> format needed to run a SQL agent batch file?  This batch
>> file is located in c:\win32app\ibm\adsm\agentsql and is
>> named daily1.bat.
>>
>> Thanks,
>> Steve Norton
>> Srnorton AT bhset DOT org