1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Select to find which backup stg pool admin sched failed and error for failure

Discussion in 'Scripting' started by sandratechie27, Jan 26, 2011.

  1. sandratechie27

    sandratechie27 New Member

    Joined:
    Jan 13, 2011
    Messages:
    5
    Likes Received:
    0
    Select to find why backup storage pool failed and the error for failure

    Hello,

    Does anyone know a select statement that will tell us which backup storage admin schedule has failed for the last 10 days and the errror for the failures I used this select statement but it does not provide the anr error for failure. Does anyone know what are we missing?

    select date(start_time) as "Start Date",time(start_time) as "Start Time",date(end_time) as "End Date",time(end_time) as "End Time",number as "Process #",activity,schedule_name,entity,bytes,successful from summary where schedule_name='ADMIN_SCHED_NAME'

    Thanks
     
  2.  
  3. cfhoffmann

    cfhoffmann New Member

    Joined:
    Jun 2, 2005
    Messages:
    108
    Likes Received:
    3
    Occupation:
    TSM Storage Specialist
    Location:
    Sydney, Australia
    If you fix the typo in 'successful' it will run, but since there are no ANR errors listed in the summary table it will never give you the result you want.
    Try running a query on the ACTLOG table instead and check the MESSAGE field.
     
  4. sandratechie27

    sandratechie27 New Member

    Joined:
    Jan 13, 2011
    Messages:
    5
    Likes Received:
    0
    Yes, but will like to know specific select statement to generate the list of errors for failures on the backup stg pool.

    Thanks for the hint
     
: script

Share This Page