[dba-SQLServer]Running a Job

Make sure that there is no "On Completion/Success exit job" setting.

Robert Djabarov
Sr. SQL Server DBA
Phone: (210) 913-3148
Pager: (210) 753-3148


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy
Pang
Sent: Friday, August 08, 2003 12:11 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Running a Job


Try run SQL Profiler and see if you returns any messages.




>From: "Mark Boyd" <MarkBoyd at mcbeeassociates.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLServerList" <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer]Running a Job
>Date: Fri, 8 Aug 2003 11:51:53 -0400
>
>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.
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com