May 11, 2006 at 3:00 pm
I'm trying to determine what are the values that may be returned in the "State" field for the xp_sqlagent_enum_jobs and what they mean.
Thanks
May 15, 2006 at 8:00 am
This was removed by the editor as SPAM
October 17, 2007 at 12:45 pm
per the comments in the msdb.dbo.sp_get_composite_job_info sp the state values are defined as follows:
0 = Not idle or suspended,
1 = Executing,
2 = Waiting For Thread,
3 = Between Retries,
4 = Idle,
5 = Suspended,
6 = WaitingForStepToFinish,
7 = PerformingCompletionActions
October 19, 2007 at 6:35 pm
Here is a link no SQL 2000 DBA should be without:
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 4, 2009 at 5:26 am
Does anyone know of an equivalent page for SQL Server 2005 DBA's please? I can't download that one for 2000 anymore, seems the help page no longer exists.
March 5, 2009 at 5:21 am
March 5, 2009 at 5:32 am
MANU (3/5/2009)
http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdfMJ
Thanks MANU. Think this shows how the tables link together etc although I can't see (correct me if I'm wrong) sysjobhistory or sysjobs strangely enough. It also doesn't show the fields within the tables (may be as it's just from a indexing relationship perspective). Do you know if there's something along these lines please and if there's something that describes the fields in that table please?
March 5, 2009 at 6:38 am
I noticed it now. Better take help from books online for this:
http://msdn.microsoft.com/en-us/library/ms174997(SQL.90).aspx
MJ
March 5, 2009 at 6:47 am
That's great thanks MANU. Will look in there...
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply