|
Last change
on this file since 6712 was
6712,
checked in by ascheibe, 13 years ago
|
|
#1233
- got db scripts up-to-date
- renamed db related stuff back to 3.3
- fixed a bug in the Status page that occured when the db is empty
|
|
File size:
938 bytes
|
| 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.3].[dbo].[Job] j
|
|---|
| 21 | ,[HeuristicLab.Hive-3.3].[dbo].[HiveExperiment] he
|
|---|
| 22 | ,[HeuristicLab.Authentication].dbo.aspnet_Users u
|
|---|
| 23 | ,[HeuristicLab.Hive-3.3].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.
