| Author: DurgaprasadCh 25 Mar 2008 | Member Level: Silver | Rating:  Points: 2 |
hey Ashref,
What status you would like to know? size, I believe only way is convert to array using ToArray method and get the length.
-Durga.
|
| Author: Ashref Khan 27 Mar 2008 | Member Level: Bronze | Rating: Points: 2 |
Thanks Durga,
let me explain more what i have :
I'm doing right now a method to get the Status of a Job Queue table in SQL server that holds the jobs to be executed this is a snapshot of the table structure:
// Job queue table (main):
CREATE TABLE [dbo].[ProcessingQueue] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Priority] [int] NULL ,
[ProcessingType] [char] (1) NOT NULL ,
[TimeSubmitted] [datetime] NOT NULL ,
[Status] [char] (1) NULL ,
[LastUpdated] [datetime] NOT NULL
what i want is to write a method to get the Status of the Job Queue given the Job ID ? and thats from an Ajax enabled website .. i was thinking of writting a StoredProcedure to return the Status value .. i'm not sure if this is the right solution ? can you help me here
Thanks
Ashref
|