ADSM-L

Re: NT SQL agent Schedule command

1998-05-22 13:13:34
Subject: Re: NT SQL agent Schedule command
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Fri, 22 May 1998 13:13:34 -0400
Mike,

Here is an example of the "define schedule" command:

  def sched sqagents sql_daily_incr desc="SQL Daily Incremental Backup"
     action=command objects="c:\win32app\ibm\adsm\agentsql\daily1.bat"
     priority=2 starttime=21:00
     duration=15 duru=minutes period=1 perunits=day dayofweek=any

Then, you must associate the SQL Agent node with the schedule like:

     define association sqagents sql_daily_incr sqlserv1

This has been tested and does work.  If you are having problems,
double check that you have the ADSM scheduler service running and that
you are using the correct ADSM options file and NODENAME for the SQL Agent.
If it is still failing, check the dsierror.log.
You can also add the following to the batch file to make sure that
you are not having environment variable problems:
  DSMI_DIR=
  DSMI_CONFIG=
  DSMI_LOG=
You must also verify that the password is set correctly and that you
can connect without being prompted while running the sqldsmc program.

Del Hoobler
ADSM Agent Development

>> Del-   ( or anyone )
>>
>> How do we get the ADSM Server scheduler to cause the
>> client to execute the command file.  (We have the NT Service
>> installed)
>>
>> Is the following correct?  Is there anything else we need?
>>
>> COMMAND=ACTION
>> OBJECTS="c:\win32app\ibm\adsm\agentsql\daily1.bat"
>>
>> ( the above doesn't seem to work )
>>
>> Thanks.   Mike Martin
<Prev in Thread] Current Thread [Next in Thread>