Welcome! » Log In » Create A New Profile

SQL STATEMENT

Posted by Lepre, James 
Lepre, James
SQL STATEMENT
January 22, 2018 06:59AM
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.
This message was imported via the External PhorumMail Module
Rick Adamson
Re: SQL STATEMENT
January 22, 2018 07:59AM
You'll need to query the Events table for this info. Modify the current time stamp as needed but I strongly suggest using it when querying the Events (and Backups) table.
Something along the lines of:

select node_name,status from events where (scheduled_start>=current_timestamp - 24 hours)

-Rick Adamson

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lepre, James
Sent: Monday, January 22, 2018 9:43 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL STATEMENT

* This email originated outside of the organization. Use caution when opening attachments or clicking links. *

----------------------------------------------------------------------
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.


**CONFIDENTIALITY NOTICE** This electronic message contains information from Southeastern Grocers, LLC and is intended only for the use of the addressee. This message may contain information that is privileged, confidential and/or exempt from disclosure under applicable Law. This message may not be read, used, distributed, forwarded, reproduced or stored by any other than the intended recipient. If you are not the intended recipient, please delete and notify the sender
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login