Loading...

GetSQLJobList

Scope

Intended Audience
All X
CommVault Internal  
CE/System Test  
Development  

Platform

  • CommServer (Database: CommServ)

Release

  • 11.0.0

Description

Return list of SQL jobs and its details. Start and End Time should be client's local Time


Usage

qoperation execscript -sn QS_GetSQLJobList -si @i_clientName = 'clientname' -si @i_instanceName='instanceName' -si @i_startTime = 'starttime' -si @i_endTime = 'endtime' -si @i_databaseName = 'dbname' -si @i_jobid = 'jobid' -si @i_backup_set_id = 'msdbbackupsetid' -si @i_details = '0 or 1'


  • script_name: QS_GetSQLJobList.
     
  • returns job list and details.
     
  • Version

  • 1.7
     
  • Disclaimer of Warranties

    CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.