Mark Boyd
MarkBoyd at McBeeAssociates.com
Fri Aug 8 12:21:47 CDT 2003
Robert - The only place I have this is in the last step. All previous steps are set up as 'On Success: Goto Next Step'. Mark -----Original Message----- From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com] Sent: Friday, August 08, 2003 1:15 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com