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