| Rev | Line | |
|---|
| [6688] | 1 | /****** Script for SelectTopNRows command from SSMS ******/
|
|---|
| [6721] | 2 | SELECT j.[TaskId]
|
|---|
| 3 | ,j.[TaskState]
|
|---|
| [6688] | 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]
|
|---|
| [6721] | 15 | ,j.[IsParentTask]
|
|---|
| [6688] | 16 | ,j.[FinishWhenChildJobsFinished]
|
|---|
| [6721] | 17 | ,j.[ParentTaskId]
|
|---|
| [6688] | 18 | , he.HiveExperimentId
|
|---|
| 19 | FROM
|
|---|
| [6721] | 20 | [HeuristicLab.Hive-3.3].[dbo].[Task] j
|
|---|
| [6712] | 21 | ,[HeuristicLab.Hive-3.3].[dbo].[HiveExperiment] he
|
|---|
| [6688] | 22 | ,[HeuristicLab.Authentication].dbo.aspnet_Users u
|
|---|
| [6721] | 23 | ,[HeuristicLab.Hive-3.3].dbo.TaskData jd
|
|---|
| [6688] | 24 | WHERE
|
|---|
| 25 | j.HiveExperimentId = he.HiveExperimentId
|
|---|
| [6721] | 26 | AND j.TaskId = jd.TaskId
|
|---|
| [6688] | 27 | AND he.OwnerUserId = u.UserId
|
|---|
| 28 | --AND he.DateCreated > '06-03-2011 10:30'
|
|---|
| 29 |
|
|---|
| [6721] | 30 | ORDER BY j.TaskState, he.DateCreated DESC |
|---|
Note: See
TracBrowser
for help on using the repository browser.
