Changeset 6721 for branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Query Jobs.sql

Timestamp:

09/08/11 13:41:25 (13 years ago)

Author:

ascheibe

Message:

#1233 Review comments: renamed Job to Task

File:

• branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Query Jobs.sql (modified) (2 diffs)

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

@@ -1 +1 @@
 /****** Script for SelectTopNRows command from SSMS  ******/
-SELECT j.[JobId]
-      ,j.[JobState]
+SELECT j.[TaskId]
+      ,j.[TaskState]
       ,j.[ExecutionTimeMs]/1000/60/60 AS ExecutionTimeHours
       ,DATALENGTH(jd.data)/1024.0/1024.0 AS MB
@@ -13 +13 @@
       ,j.[IsPrivileged]
       ,j.[Command]
-      ,j.[IsParentJob]   
+      ,j.[IsParentTask]   
       ,j.[FinishWhenChildJobsFinished]
-      ,j.[ParentJobId]
+      ,j.[ParentTaskId]
       , he.HiveExperimentId
   FROM 
-  [HeuristicLab.Hive-3.3].[dbo].[Job] j
+  [HeuristicLab.Hive-3.3].[dbo].[Task] j
   ,[HeuristicLab.Hive-3.3].[dbo].[HiveExperiment] he
   ,[HeuristicLab.Authentication].dbo.aspnet_Users u
-  ,[HeuristicLab.Hive-3.3].dbo.JobData jd
+  ,[HeuristicLab.Hive-3.3].dbo.TaskData jd
   WHERE
   j.HiveExperimentId = he.HiveExperimentId
-  AND j.JobId = jd.JobId
+  AND j.TaskId = jd.TaskId
   AND he.OwnerUserId = u.UserId
   --AND he.DateCreated > '06-03-2011 10:30'
   
-ORDER BY j.JobState, he.DateCreated DESC
+ORDER BY j.TaskState, he.DateCreated DESC