[dba-SQLServer] Schudeled Items?

thnx for you're reply Debbie,

i did some digging on MSDN and found several usefull
tables in the MSDB database:
sysjobs
sysjobsteps
sysjobhistory
sysjobschedules

select *
from sysjobschedules
where freq_type = 4

With these I found out wich jobs where scheduled.

The job that fires over and over is TestFromBill.

However I do NOT see this job?!? Could it be that this
one is deleted/corrupted somehow but the scheduling
wasn't deleted??

Regards,

Sander
--- "Elam, Debbie" <DElam at jenkens.com> wrote:

> Why don't you look at the list of scheduled jobs? 
> Find the ones that ran
> last at 16:00 hours and narrow the list from there. 
> I know my SQL
> Enterprise Manager has a Last Run Status (Start
> Date) field that can be
> sorted.
> 
> Debbie
> 
> -----Original Message-----
> From: S D [mailto:sqlserver667 at yahoo.com] 
> Sent: Tuesday, August 24, 2004 5:41 AM
> To: sqlserver667
> Subject: [dba-SQLServer] Schudeled Items?
> 
> 
> Hi group,
> 
> I (urgently) need to find out wich DTS/SP object is
> scheduled at 16:00 hours.
> 
> It is sending a lot of mail and this is very
> annoying
> and can cause problems in due time.
> 
> So, my question:
> how can I figure out wich DTS/SP is scheduled?
> 
> TIA
> 
> Sander
> PS: We've got over a 1000 DTS/SP objects in our
> development street so I do not hope that I have to
> check them 1-by-1 :-)
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> http://promotions.yahoo.com/new_mail 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
>
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> - JENKENS & GILCHRIST E-MAIL NOTICE - This
> transmission may be: (1) subject
> to the Attorney-Client Privilege, (2) an attorney
> work product, or (3)
> strictly confidential. If you are not the intended
> recipient of this
> message, you may not disclose, print, copy or
> disseminate this information.
> If you have received this in error, please reply and
> notify the sender
> (only) and delete the message. Unauthorized
> interception of this e-mail is a
> violation of federal criminal law. 
> This communication does not reflect an intention by
> the sender or the
> sender's client or principal to conduct a
> transaction or make any agreement
> by electronic means.  Nothing contained in this
> message or in any attachment
> shall satisfy the requirements for a writing, and
> nothing contained herein
> shall constitute a contract or electronic signature
> under the Electronic
> Signatures in Global and National Commerce Act, any
> version of the Uniform
> Electronic Transactions Act or any other statute
> governing electronic
> transactions.
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
>
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail