Re: [ADSM-L] SQL STATEMENT

Hi James,

There is probably an example like you are looking for here:
http://thobias.org/tsm/sql/

-
Thanks,
Marc...
________________________________________________________
Marc Lanteigne
Accelerated Value Specialist for Spectrum Protect
416.478.0233 | marclanteigne AT ca.ibm DOT com
Office Hours:  Monday to Friday, 7:00 to 16:00 Eastern

Follow me on: Twitter, developerWorks, LinkedIn


-----Original Message-----
From: Lepre, James [mailto:james.lepre AT SOLIXINC DOT COM]
Sent: Monday, January 22, 2018 10:45 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL STATEMENT

Hey Everyone -

   I am looking for a sql select statement that show completions, missed,
and failures of daily schedules.  This output should be similar to the q
event command

Thank you in advance for the assistance



James Lepre




---------------------------------------------------------------

Confidentiality Notice: The information in this e-mail and any

attachments thereto is intended for the named recipient(s) only

.  This e-mail, including any attachments, may contain information

that is privileged and confidential  and subject to legal restrictions

and penalties regarding its unauthorized disclosure or other use.

  If you are not the intended recipient, you are hereby notified

that any disclosure, copying, distribution, or the taking of any

action or inaction in reliance on the contents of this e-mail and

 any of its attachments is STRICTLY PROHIBITED.  If you

 have received this e-mail in error, please immediately notify

 the sender via return e-mail; delete this e-mail and all attachments

from your e-mail  system and your computer system and network;

 and destroy any paper copies you may have in your possession.

Thank you for your cooperation.