You can run something like:

select database_name from db where hour(current timestamp)>16

The return code will be 0 if the hour is greater than 16 and 11 otherwise.

Thomas Denier
Thomas Jefferson University Hospital

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Vandeventer, Harold [OITS]
Sent: Tuesday, October 21, 2014 11:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Script snipet for "current hour"

Does anyone have a bit of script code that evaluates the "current hour" when 
the script is running?

Something like
                IF SELECT HOUR(CURRENT_TIMESTAMP) FROM LOG > 16 GOTO ...

I've poked around ADSM.QuickFacts and see some potential hints.  SELECT 
HOUR(CURRENT_TIMESTAMP) FROM LOG will return the current hour, but I can't get 
an if test to evaluate that hour saved as a script.

My goal: A script runs and it schedules a secondary script to run at a future 
time.

When the secondary script runs, it tests for various conditions (active node 
sessions, reclamation, etc.) and MIGHT reschedule itself for "STARTT=NOW+00:15".

But, that secondary script will ideally also test for the time that it started. 
 If the start time is past a given time of day (say 16:00), I want the script 
to skip its intended purpose and delete the schedule that fired it off.
The information contained in this transmission contains privileged and 
confidential information. It is intended only for the use of the person named 
above. If you are not the intended recipient, you are hereby notified that any 
review, dissemination, distribution or duplication of this communication is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender by reply email and destroy all copies of the original message.

CAUTION: Intended recipients should NOT use email communication for emergent or 
urgent health care matters.