Thanks Marcus, I appreciate the insights

Thanks Brian and Eddie.  I really appreciate the help!

Not exactly clear Ajit.  Can you post an example?  Maybe that will make it clearer.  Thanks!

I did get the error message after running the SP. 

Running the declare before executing the stored procedure worked in Query Analyzer, but I don't know if that can...

Thanks Joe!

Thanks for the info Steve, I'll give it a try!  I never got an email notification about the post, and I've been so busy recently I haven't had time to...

Thanks Kathikeyan, but that is just test data (I should have been more specific about that).  The actual names of the directories are not in any type of sortable order). ...

Cool, thanks Dan!

Thanks!  I found the option to restart the service in W2K and SQL2K.  In SQL2K it's under the Advanced tab of SQL Server Agent Properties in Enterprise Manager.

I think I'll...

Great ideas Bill!  I'll look into both of them.  I didn't even think about either of those options, but they make so much sense!

Bill

Bill,

I've never used the CmdExec function in the job steps before, but it seemed simple enough.  Unfortunately I'm having an issue.  I created a simple batch file with the commands...

Great - thanks Bill!