I'm having to import data from an AS400 IBM Mainframe and do nightly exports from Microsoft SQL Server 2000 back to the AS400 IBM Mainframe. I was wondering if there was a way to schedule a stored procedure to run a job at a specific time. More importantly if there was to bring the database down for this maintenance, and run the job. Once the morning import has occurred, then have the database come back online. I would also need to format the data file and export it as a text delimited file and upload it to the mainframe. I know this is a multi-part task I'm talking about. I was wondering if there was any way to automate it any bit.