[dba-SQLServer]Running a Job

Post your exact code.

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com]
Sent: Friday, August 08, 2003 2:15 PM
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/20030808/ac12246a/attachment.html>