Thank for the reply Tim.

I'll try Conditional split bu I think the Error output is the way to go for me.

The Sysjobschedules will always show 0 until it gets refreshed.

Check the Jobs Activity Monitor and you will see Next Run Time is filled.

Justin how about this.

Change the schedule of the job from 11:00AM to 11:30AM.

Did you read about Roles in BOL.

http://technet.microsoft.com/en-us/library/ms174840.aspx

Right click on SQL Agent ---->Properties in the general tab check the "Include execution trace messages"

This will drill down to what's causing the errror.

Create a new job to execute the...

All scripts were copied from SQL Central Scripts section.

This script will show you all the foreign keys in your database.

select so1.Name as FKConstraint, so.Name as FromTable,

  sc.Name as FromColumn, so2.Name as...

You have to highlight your sql statement in Query Analyzer and then select Index tunning wizard from the Query menu.

You can't change this setting (http://msdn2.microsoft.com/en-us/library/ms188924.aspx)

Is this job enabled when you query sysjobs table in msdb?

What's the purpose of this job?

Did Sql Agent service account changed? like a new password? 

no idea.

but i'm guessing it was fixed in SP2.

Sysjobschedules refreshes every 20 minutes.

Are schedules enabled after you make the changes?

Is SQL Agent running?

Ian the limit is 64 tables. you must select 64 tables at a time.

This table jptsys_isel_dflt is the limit.

I'm not sure if Microsoft fixed this in...

SQL 2005 32 bit will run in the WOW64 subsystem

AWE is not needed and cannot be configured on 64-bit operating systems.

I'm not familiar with SAP servers but i think you...

I'm stuck on the same error.

Hopefully someone will find a better way but for now i use a staging table where i move the date into varchar(8) and then i...

Linked server is the best option

Thank you for replying so fast.

No errors during parsing.

Ken I'm using the second method and i'm going to use underlying tables since we've cleaned up most of the tables.

Query...