Hello

Try this for a starter:

select * from summary where schedule_name is not null and 
start_time>current_timestamp - 24 hours

That will list all scheduled tasks from the summary table that started in 
the last 24 hours.

You can replace the * with a comma separated list of fields you need.  Try 
it out and feedback if it's not what you need.

Steven

Steven Langdale
Global Information Services
EAME SAN/Storage Planning and Implementation
( Phone : +44 (0)1733 584175
( Mob: +44 (0)7876 216782
ü Conference: +44 (0)208 609 7400 Code: 331817
+ Email: steven.langdale AT cat DOT com

 



Pavel Sitnikov <SitnikovPG AT URALSIBBANK DOT RU> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
25/06/2009 11:12
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
[ADSM-L] How can I insert "Completed" column in report?




Caterpillar: Confidential Green Retain Until: 25/07/2009 



Hi,
 sql queries guru
need some script for my custom OR rep with output like TSM command "q ev *
* f=d"
I know about standart "Client Schedules Status" report and use it. But it
have only one option setting in OR - Node Filter. And report output
doesn't have "Completed" column, only  "Schedule Start" and "Actual
Start". Command output "q ev * * f=d" include this column.
How can I insert "Completed" column in report?

Thx in advance!