Shekhar,

My hourly log schedule looks like this:

            Policy Domain Name: BWCSQL
                 Schedule Name: LOGHOUR
                   Description:
                        Action: Command
                       Options:
                       Objects: c:\SQLLOG.CMD
                      Priority: 5
               Start Date/Time: 11/18/2002 07:30:00
                      Duration: 20 Minute(s)
                        Period: 1 Hour(s)
                   Day of Week: Any
                    Expiration:
Last Update by (administrator): ADMIN
         Last Update Date/Time: 12/16/2002 12:56:17
              Managing profile:

and the SQLLOG.CMD file just says:

 %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
sqlserver=msbwc8 /sqlauth=int /sqlbuff=4 /sqlbuffersize=2048
/logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlsched.log


Glen Churchfield
-----Original Message-----
From: shekhar Dhotre
To: ADSM-L AT VM.MARIST DOT EDU
Sent: 2/7/2003 10:56 AM
Subject: backup every hour in TSM ..

Hi All,

we want to backup  oracle transaction logs every hour /everyday of the
week .Currently the model of backing up everything once a day permits
losing an entire days worth of data which isn't necessary.

Any ideas on how I can  schedule this job in TSM ?


Thank You

Shekhar Dhotre.
Sr.Midrange Engineer.
Lend Lase , GSDC.
www.lendlease.com