Free cookie consent management tool by TermsFeed Policy Generator

source: branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Query Jobs.sql @ 6721

Last change on this file since 6721 was 6721, checked in by ascheibe, 13 years ago

#1233 Review comments: renamed Job to Task

File size: 947 bytes
Line 
1/****** Script for SelectTopNRows command from SSMS  ******/
2SELECT j.[TaskId]
3      ,j.[TaskState]
4      ,j.[ExecutionTimeMs]/1000/60/60 AS ExecutionTimeHours
5      ,DATALENGTH(jd.data)/1024.0/1024.0 AS MB
6      ,he.Name AS Experiment
7      ,he.DateCreated   
8      ,u.UserName
9      ,j.[LastHeartbeat]
10      ,j.[Priority]
11      ,j.[CoresNeeded]
12      ,j.[MemoryNeeded]
13      ,j.[IsPrivileged]
14      ,j.[Command]
15      ,j.[IsParentTask]   
16      ,j.[FinishWhenChildJobsFinished]
17      ,j.[ParentTaskId]
18      , he.HiveExperimentId
19  FROM
20  [HeuristicLab.Hive-3.3].[dbo].[Task] j
21  ,[HeuristicLab.Hive-3.3].[dbo].[HiveExperiment] he
22  ,[HeuristicLab.Authentication].dbo.aspnet_Users u
23  ,[HeuristicLab.Hive-3.3].dbo.TaskData jd
24  WHERE
25  j.HiveExperimentId = he.HiveExperimentId
26  AND j.TaskId = jd.TaskId
27  AND he.OwnerUserId = u.UserId
28  --AND he.DateCreated > '06-03-2011 10:30'
29 
30ORDER BY j.TaskState, he.DateCreated DESC
Note: See TracBrowser for help on using the repository browser.