[dba-SQLServer]Running a Job

John -

It tells me that all steps have succeeded.

I know the sprocs aren't running because normally they each take about
30 minutes to run.

When I run the sprocs in a job, they each run for about a second, then
return successful.

 

Mark

 

-----Original Message-----
From: DJK(John) Robinson [mailto:djkr at msn.com] 
Sent: Saturday, August 09, 2003 4:20 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Running a Job

 

Mark

 

In the Job History, have you checked whether any/all of the individual
job steps have succeeded?

 

John

 

	-----Original Message-----
	From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
Boyd
	Sent: 08 August 2003 19:15
	To: dba-sqlserver at databaseadvisors.com
	Subject: RE: [dba-SQLServer]Running a Job

	Eric -

	The job history is telling me it succeeded, but I can tell the
sprocs in the steps didn't execute.

	 

	Mark

	 

	-----Original Message-----
	From: Eric Barro [mailto:ebarro at afsweb.com] 
	Sent: Friday, August 08, 2003 12:06 PM
	To: dba-sqlserver at databaseadvisors.com
	Subject: RE: [dba-SQLServer]Running a Job

	 

	Mark,

	 

	Check the Job History details to see if it succeeded or failed.

	 

	---
	Eric Barro
	Senior Systems Analyst
	Advanced Field Services
	(208) 772-7060
	http://www.afsweb.com <http://www.afsweb.com/>  

		-----Original Message-----
		From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mark
Boyd
		Sent: Friday, August 08, 2003 8:52 AM
		To: SQLServerList
		Subject: [dba-SQLServer]Running a Job

		I am attempting to run a job thru SQL2000 Enterprise
Mgr.

		This job consists of 6 steps, each containing a sproc in
the command.

		When I go to run the job, it finishes successfully in
about 5 seconds, but doesn't seem to run any of the sprocs.

		Each step looks like the following: execute spSproc.

		Am I missing something?

		Any ideas?

		 

		TIA,

		Mark Boyd

		Sr. Systems Analyst

		McBee Associates, Inc.

		 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030811/08692e96/attachment.html>