Forum Discussion

noazara's avatar
noazara
Level 6
12 years ago
Solved

we have 1500 clients in our backup rotation

Hi Folks,

Please provide me the scripts that I can use in my environment for backup jobs/clients  which are running more than 24 hours.

 

Please provide the detailed steps.I meean how to create the script file and how to run that.

 

NBU 7.1

LINUX(tikanga)

 

7.1.x and Earlier
Backup and Recovery
NetBackup
  • Nicolai's avatar
    Nicolai
    12 years ago

    The shebang expiression added, this script is written for Korn shell not Bash. Path to bpdbjobs is now full

    But do take a look at my previos post that contain a link to a perl script that do the same.The script below is one I wrote and then replaved with a perl version. 

    #!/usr/bin/ksh
ALARM_TRESHOLD=84000
RUNTIME=0
/usr/openv/netbackup/bin/admincmd/bpdbjobs -most_columns | awk -F "," ' $3 ~ /^1$/ { print } ' |  awk -F "," ' $2 ~ /^0$/ { print } '  | awk -F "," '{ print $1, $3, $6, $7, $10 }' | while read  PID STATE SCHEDULE CLIENT RUNTIME
do
 if [ RUNTIME -gt ALARM_TRESHOLD ]
  then
     echo "Job ${PID} ${CLIENT} ${SCHEDULE} runtime is ${RUNTIME}. It's exceeded runtime treshold of ${ALARM_TRESHOLD} "
   fi
done

24 Replies

Sort By
  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    12 years ago

    Noazara,

    Please see forum post - https://www-secure.symantec.com/connect/forums/long-running-or-hung-jobs-script#comment-3583201

    ALARM_TRESHOLD=84000
RUNTIME=0
bpdbjobs -most_columns | awk -F "," ' $3 ~ /^1$/ { print } ' |  awk -F "," ' $2 ~ /^0$/ { print } '  | awk -F "," '{ print $1, $3, $6, $7, $10 }' | while read  PID STATE SCHEDULE CLIENT RUNTIME
do
 if [ RUNTIME -gt ALARM_TRESHOLD ]
  then
     echo "Job ${PID} ${CLIENT} ${SCHEDULE} runtime is ${RUNTIME}. It's exceeded runtime treshold of ${ALARM_TRESHOLD} "
   fi
done

     

    However, if you are already using OpsCenter for reporting, you can setup an alert for long running jobs.

    If you have any questions, please let me know.

     

    -Tom

     

  • noazara's avatar
    noazara
    Level 6
    12 years ago

    Thanks.

     

    But how to start this script.I mean how to create this.

     

    I need to run sudo vi first?

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    12 years ago

    noazara,

    Yes, you will need to create a file in linux first... name it something like jobs_over_24_hours.sh

    Then use vi to modify the contents of the file.

    Once you save it, execute the script to see if it works.

    You may want to modify the ALARM_THRESHOLD value from 84000 to 3600 to monitor jobs over 1 hour first for testing.

    Once you have the script working, adjust the value back to 84000 for 24 hour jobs.

    --Tom

     

  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    Seems you need basic Unix training? 

    Please do not expect to get it in a NetBackup forum....

    The script is extremely helpful. Please mark Tom's post as Solution and ask your Unix administrator for further assistance.

  • noazara's avatar
    noazara
    Level 6
    12 years ago

    -bash-3.2$ sudo ./24.sh

    ./24.sh: line 3: bpdbjobs: command not found

     

     

    -bash-3.2$ cat 24.sh

    ALARM_TRESHOLD=84000

    RUNTIME=0

    bpdbjobs -most_columns | awk -F "," ' $3 ~ /^1$/ { print } ' |  awk -F "," ' $2 ~ /^0$/ { print } '  | awk -F "," '{ print $1, $3, $6, $7, $10 }' | while read  PID STATE SCHEDULE CLIENT RUNTIME

    do

    if [ RUNTIME -gt ALARM_TRESHOLD ]

      then

         echo "Job ${PID} ${CLIENT} ${SCHEDULE} runtime is ${RUNTIME}. It's exceeded runtime treshold of ${ALARM_TRESHOLD} "

       fi

    done

     

     

    Getting the above error !!!

  • Ankit_Maheshwar's avatar
    Ankit_Maheshwar
    Level 5
    12 years ago

    tom_sprouse..

    As an option we can add below path in this script to run from any path...

     

    cd /usr/openv/netbackup/bin/admincmd

     

     

  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    If you don't have a PATH variable set, add the full path to bpdbjobs:
    /usr/openv/netbackup/bin/admincmd/bpdbjobs

    Please - this is Unix basics.....

  • noazara's avatar
    noazara
    Level 6
    12 years ago

     

    -bash-3.2$ sudo ./24.sh

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

    ./24.sh: line 7: [: RUNTIME: integer expression expected

     

    -bash-3.2$ cat 24.sh

    PATH=$PATH:/usr/openv/netbackup/bin:/usr/openv/netbackup/bin/admincmd

     

    ALARM_TRESHOLD=84000

    RUNTIME=0

    bpdbjobs -most_columns | awk -F "," ' $3 ~ /^1$/ { print } ' |  awk -F "," ' $2 ~ /^0$/ { print } '  | awk -F "," '{ print $1, $3, $6, $7, $10 }' | while read  PID STATE SCHEDULE CLIENT RUNTIME

    do

    if [ RUNTIME -gt ALARM_TRESHOLD ]

      then

         echo "Job ${PID} ${CLIENT} ${SCHEDULE} runtime is ${RUNTIME}. It's exceeded runtime treshold of ${ALARM_TRESHOLD} "

       fi

    done