sql job failed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sql job failed

Author

Topic

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 10:56:01

i'm trying to investigate a job that stopped running.
i used this site http://www.databasejournal.com/features/mssql/article.php/3285691
but i still cant find what stopped the process.
any input will be appreciated.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-04-10 : 12:02:03

did it just stop running, or does it fail? if fail, what is error messages? what do u see in event log?

if just stopped running, is sql agent running? any recent pwd change on service account for sqlagent? is job still scheduled? was schedule set to expire?

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 14:15:35

did it just stop running, or does it fail? if fail, what is error messages? what do u see in event log?
it failed at 4am. It works if it is run manually.
i cant remember the error msg.
even log doesn't tell anything

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-04-10 : 14:19:23

is this the first time it failed? what does the job do? if u right-click the job and view history, there will be some clue as to the nature of the failure. even better is if logging is turned on, in which case the log will have detailed information of the failure. did u try rerunning? we are going to need a lot more info to be helpful here.

since it works if u execute manually, may be that service account doesnt have permission. but until we know what the job does, thats just a guess

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-10 : 14:30:30

quote:
Originally posted by gongxia649

i cant remember the error msg.

How do you expect us to help without the error message?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 15:09:20

When creating a new job on sql 2005 it shows me this error:

unable to cast object of type of
'microsoft.sql server.management.smo.simpleobjectkey' to type
'microsoft.sqlserver.management.smo.agent.jobobjectkey'

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 15:11:13

russel,
not the first time. it copies the tables from one db into another.
i reran it and it works. But i dunno why it failed at 4am

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-10 : 15:13:24

quote:
Originally posted by gongxia649

When creating a new job on sql 2005 it shows me this error:

unable to cast object of type of
'microsoft.sql server.management.smo.simpleobjectkey' to type
'microsoft.sqlserver.management.smo.agent.jobobjectkey'

We need the error from when the job failed at 4am and not the error you get when creating jobs.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 15:40:42

tkizer,

Job 'D - (C) IPDB_Update To IPGDB' : Step 1, 'IPDB Replicate' : Began Executing 2007-04-07 04:00:00

Job 'D - (C) IPDB_Update To IPDB' : Step 1, 'IPDB Replicate' : Began Executing 2007-04-08 04:00:00

Msg 0, Sev 0: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]
Job 'D - (C) IPDB_Update To IPDB' : Step 1, 'IPDB Replicate' : Began Executing 2007-04-10 04:00:00

Msg 0, Sev 0: Operation canceled [SQLSTATE HY008]

Query cancelled.
Job 'D - (C) IPDB_Update To IPDB' : Step 1, 'IPDB Replicate' : Began Executing 2007-04-10 10:03:30

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-10 : 16:07:55

I am not familiar with those errors. Could you post the job steps?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-10 : 22:29:21

tkizer,
calls: EXEC asp_Replicate_IP_data

step name: ipdb replicate

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-04-11 : 09:26:23

"Unspecified error occurred on SQL Server. Connection may have been terminated by the server"

is the sp accessing a linked server? sounds like either remote server is rebooting or u have network issues. still until we know what the SP does, we have to try to read your mind! Even Tara isn't THAT good (unless u are in the same room with her)

gongxia649
So Suave

344 Posts

Posted - 2007-04-11 : 17:02:47

russel,
the SP copies all the tables from 1 server to another server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-11 : 17:10:08

quote:
Originally posted by gongxia649

russel,
the SP copies all the tables from 1 server to another server

That doesn't help us help you. Please post the code.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources