[dba-SQLServer]Running a Job

SQL Profiler is a graphical tool that allows system administrators to 
monitor events in an instance Microsoft SQL Server.  This includes whether 
or not a sproc has been executed from job.  Of course, this assumes that you 
already checked

To access Profiler, go to Start Menu, Programs, SQL Server, Profiler

>From Profiler, go to FILE, NEW, TRACE...

Connect to the SQL Server where the Job is executed.

Use the following template: SQLProfilerTSQL

Click RUN.

Go and execute your Job again and see if you notice any activity there.  
There will be a lot of records to sift through but if your sproc ran, it 
will show up here.  To reduce the number of the records displayed here, use 
the FILTER tab from the previous screen.

A quick way of locating your sproc is to CTRL-F and search for the name of 
your sproc in the "Data Column".

good luck.  let us know if you find anything.

Billy




>From: "Mark Boyd" <MarkBoyd at mcbeeassociates.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]Running a Job
>Date: Fri, 8 Aug 2003 13:19:03 -0400
>
>Billy -
>I have never used this utility.
>Can you provide more info?
>
>Thanks,
>Mark
>
>-----Original Message-----
>From: Billy Pang [mailto:tuxedo_man at hotmail.com]
>Sent: Friday, August 08, 2003 1: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
>

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail

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