Jobs not running in SQL Server agent as per schedule

Question

I have a Job set up in Sql server agent which is supposed to run at 2:15 AM everyday. But its not running at all since last week.

Error Message:

    Could not allocate a new page for database ‘CollegeReporting’ 
    because of insufficient disk space in Filegroup ‘PRIMARY’.  
    Create the necessary space by dropping objects in the filegroup, 
    or setting autogrowth on for existing files in the filegroup.
    [SQLSTATE 42000] (Error 1101) The step failed.

Even tried starting SQL Server Agent in Services.msc and it appears greyed out.

Error Log shows as below:

Any idea what is going wrong?

Thanks, Ar

Solution

Right click on the Database CollegeReporting and select Properties.

Click on Files and then click on the Elipses ... for your data file.

Make sure Enable AutoGrowth is checked and then set your File growth increments.

Make sure Unlimited is checked on.

Repeat this for every data and log file.

Click OK and restart your job.

Comments

[Aruna Raghunam]

Steve, I increased this and scheduled job but it gives me Lock request timeout period exceeded Error: 1222 as I try to open Tables and Views...any idea on this?

[Steve Mangiameli]

If you're database is now able to grow and you are having locking issues, you will want to figure out what you are doing to lock the object(s) for so long. Also, go through the AutoGrowth exercise with tempdb and any other databases that might be capped.