Hi all... I am very new to SQL server and have an issue that I'm just not making any headway on...

I installed SQL express and have had it running for some time now.. I noticed that every night at 1:00 AM exactly, a series of jobs get started... What happens is that these jobs hold my database files that the website needs.. and the site fails login due to the fact that it is being used by another program... I saw a lot of information on the web regarding the SQL reporting services but it doesn't come with the express version.

Can someone please let me know what script I need to run to see what is queued up to run at what time..I need to find out what exactly is running, what the purpose is and ultimately, change the start time of those to correspond to the maintenance window of the site, which is 4:00 AM when there is no traffic...

thanks in advance

Gary

MS Sql Server LazyDBA home page