I just found the answer on my own.  In my Transform Data Task, I had checked the box for "7.0 format".  The box is in the "Options" tab of the...

Thanks for that catch. However, I'm still getting the same syntax error even after I changed the script to sysjobs.

I have to say that I like this one the best. It gives me all the information I want and only took 1 second of execution time.

Thanks Dave.

Frank and Gabor:

Thanks for the suggestions. My only issue with your scripts is that they either don't return the index keys (Gabor) or they return the index keys in...

I agree with you on the "paper DBA" argument. For the record, I am currently working as a DBA with SQL Server. I've also completed a Master's degree...