Job Status

Hey guys,

I need to know the current status for a job that i started.

I knew that sp_help_job give me all this information, but i have to do IFs, so I have to set a variable with this result. I only need the columns last_run_outcome and current_execution_status.

How do I to get only this values from a Job_id ??

i Looked in almost all table from msdb to find these 2 columns and nothing ... :/

Anyone can helpme ?The Answer Is :

use master
exec sp_addlinkedserver @.server = 'LocalServer',
@.srvproduct = '',
@.provider = 'SQLOLEDB',
@.datasrc = @.@.servername
go

select last_run_outcome, current_execution_status from openquery(LocalServer, 'set fmtonly off; exec msdb.dbo.sp_help_job')
go
exec sp_dropserver 'LocalServer'

U donot need to drop the linked server, I did that to ensure that noerror will be shoed when adding linked servers

Bye

Job failed with error 3624

Hi Guys,
In my develoment server, I got error with 3624 when job running, error
message is like:
Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
[SQLSTATE 01000] (Error 3624). The step failed.
The server was very slow, and like hang up. I cannot connect to server from
my computer. after while, maybe 4 minutes roughly, the server was recovered.
I got that error, and the job runing correctly.
the job runs every one minute to pupulate into a table, which selected from
other tables, and server is a subscriber server that has data replicated
from other server. Can somebody tell me what is reason? Thanks.
Why nobody answer me this question? nobody had this error?
"Iter" wrote:

> Hi Guys,
> In my develoment server, I got error with 3624 when job running, error
> message is like:
> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> [SQLSTATE 01000] (Error 3624). The step failed.
> The server was very slow, and like hang up. I cannot connect to server from
> my computer. after while, maybe 4 minutes roughly, the server was recovered.
> I got that error, and the job runing correctly.
> the job runs every one minute to pupulate into a table, which selected from
> other tables, and server is a subscriber server that has data replicated
> from other server. Can somebody tell me what is reason? Thanks.
|||This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
case with MS if DBCC doesn't report a corruption).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...[vbcol=seagreen]
> Why nobody answer me this question? nobody had this error?
>
> "Iter" wrote:
|||I checked the database with dbcc checkdb, no error reported. Is this sql
server software bug? Thanks.
"Tibor Karaszi" wrote:

> This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
> case with MS if DBCC doesn't report a corruption).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
>
|||Yes, if the database comes out clean, I'd strongly suspect a bug. Perhaps you can try this on the
most recent service pack and/or check if there are hotfixes available for this?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:C5F65767-84F7-4E7A-9E8E-444CBA9F55EB@.microsoft.com...[vbcol=seagreen]
>I checked the database with dbcc checkdb, no error reported. Is this sql
> server software bug? Thanks.
>
> "Tibor Karaszi" wrote:

Job failed with error 3624

Hi Guys,
In my develoment server, I got error with 3624 when job running, error
message is like:
Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
Location: p:\sql\ntdbms\storeng\drs\include\record
.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
[SQLSTATE 01000] (Error 3624). The step failed.
The server was very slow, and like hang up. I cannot connect to server from
my computer. after while, maybe 4 minutes roughly, the server was recovered.
I got that error, and the job runing correctly.
the job runs every one minute to pupulate into a table, which selected from
other tables, and server is a subscriber server that has data replicated
from other server. Can somebody tell me what is reason? Thanks.Why nobody answer me this question? nobody had this error?
"Iter" wrote:

> Hi Guys,
> In my develoment server, I got error with 3624 when job running, error
> message is like:
> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> Location: p:\sql\ntdbms\storeng\drs\include\record
.inl:1447 Expression:
> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> [SQLSTATE 01000] (Error 3624). The step failed.
> The server was very slow, and like hang up. I cannot connect to server fro
m
> my computer. after while, maybe 4 minutes roughly, the server was recovere
d.
> I got that error, and the job runing correctly.
> the job runs every one minute to pupulate into a table, which selected fro
m
> other tables, and server is a subscriber server that has data replicated
> from other server. Can somebody tell me what is reason? Thanks.|||This can either be a corruption in the database (see DBCC CHECKDB) or a bug
in the product (open a
case with MS if DBCC doesn't report a corruption).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...[vbcol=seagreen]
> Why nobody answer me this question? nobody had this error?
>
> "Iter" wrote:
>|||I checked the database with dbcc checkdb, no error reported. Is this sql
server software bug? Thanks.
"Tibor Karaszi" wrote:

> This can either be a corruption in the database (see DBCC CHECKDB) or a bu
g in the product (open a
> case with MS if DBCC doesn't report a corruption).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
>|||Yes, if the database comes out clean, I'd strongly suspect a bug. Perhaps yo
u can try this on the
most recent service pack and/or check if there are hotfixes available for th
is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:C5F65767-84F7-4E7A-9E8E-444CBA9F55EB@.microsoft.com...[vbcol=seagreen]
>I checked the database with dbcc checkdb, no error reported. Is this sql
> server software bug? Thanks.
>
> "Tibor Karaszi" wrote:
>

Job failed with error 3624

Hi Guys,
In my develoment server, I got error with 3624 when job running, error
message is like:
Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
[SQLSTATE 01000] (Error 3624). The step failed.
The server was very slow, and like hang up. I cannot connect to server from
my computer. after while, maybe 4 minutes roughly, the server was recovered.
I got that error, and the job runing correctly.
the job runs every one minute to pupulate into a table, which selected from
other tables, and server is a subscriber server that has data replicated
from other server. Can somebody tell me what is reason? Thanks.Why nobody answer me this question? nobody had this error?
"Iter" wrote:
> Hi Guys,
> In my develoment server, I got error with 3624 when job running, error
> message is like:
> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> [SQLSTATE 01000] (Error 3624). The step failed.
> The server was very slow, and like hang up. I cannot connect to server from
> my computer. after while, maybe 4 minutes roughly, the server was recovered.
> I got that error, and the job runing correctly.
> the job runs every one minute to pupulate into a table, which selected from
> other tables, and server is a subscriber server that has data replicated
> from other server. Can somebody tell me what is reason? Thanks.|||This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
case with MS if DBCC doesn't report a corruption).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
> Why nobody answer me this question? nobody had this error?
>
> "Iter" wrote:
>> Hi Guys,
>> In my develoment server, I got error with 3624 when job running, error
>> message is like:
>> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
>> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
>> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
>> [SQLSTATE 01000] (Error 3624). The step failed.
>> The server was very slow, and like hang up. I cannot connect to server from
>> my computer. after while, maybe 4 minutes roughly, the server was recovered.
>> I got that error, and the job runing correctly.
>> the job runs every one minute to pupulate into a table, which selected from
>> other tables, and server is a subscriber server that has data replicated
>> from other server. Can somebody tell me what is reason? Thanks.|||I checked the database with dbcc checkdb, no error reported. Is this sql
server software bug? Thanks.
"Tibor Karaszi" wrote:
> This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open a
> case with MS if DBCC doesn't report a corruption).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
> > Why nobody answer me this question? nobody had this error?
> >
> >
> > "Iter" wrote:
> >
> >> Hi Guys,
> >> In my develoment server, I got error with 3624 when job running, error
> >> message is like:
> >> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> >> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
> >> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> >> [SQLSTATE 01000] (Error 3624). The step failed.
> >> The server was very slow, and like hang up. I cannot connect to server from
> >> my computer. after while, maybe 4 minutes roughly, the server was recovered.
> >> I got that error, and the job runing correctly.
> >> the job runs every one minute to pupulate into a table, which selected from
> >> other tables, and server is a subscriber server that has data replicated
> >> from other server. Can somebody tell me what is reason? Thanks.
>|||Yes, if the database comes out clean, I'd strongly suspect a bug. Perhaps you can try this on the
most recent service pack and/or check if there are hotfixes available for this?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:C5F65767-84F7-4E7A-9E8E-444CBA9F55EB@.microsoft.com...
>I checked the database with dbcc checkdb, no error reported. Is this sql
> server software bug? Thanks.
>
> "Tibor Karaszi" wrote:
>> This can either be a corruption in the database (see DBCC CHECKDB) or a bug in the product (open
>> a
>> case with MS if DBCC doesn't report a corruption).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Iter" <Iter@.discussions.microsoft.com> wrote in message
>> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
>> > Why nobody answer me this question? nobody had this error?
>> >
>> >
>> > "Iter" wrote:
>> >
>> >> Hi Guys,
>> >> In my develoment server, I got error with 3624 when job running, error
>> >> message is like:
>> >> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
>> >> Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:
>> >> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
>> >> [SQLSTATE 01000] (Error 3624). The step failed.
>> >> The server was very slow, and like hang up. I cannot connect to server from
>> >> my computer. after while, maybe 4 minutes roughly, the server was recovered.
>> >> I got that error, and the job runing correctly.
>> >> the job runs every one minute to pupulate into a table, which selected from
>> >> other tables, and server is a subscriber server that has data replicated
>> >> from other server. Can somebody tell me what is reason? Thanks.
>>