CODEWITHSUNDEEP
sql-serversql-server-2008-r2schedulerjobsmanual
Aruna Raghunam
Aruna Raghunam

Reputation: 921

Jobs not running in SQL Server agent as per schedule

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.

Job History

Job History 1

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.

SQL Server Agent Services

Error Log shows as below:

Error Log

Any idea what is going wrong?

Thanks, Ar

Upvotes: 2

Views: 16574

Answers (1)

Steve Mangiameli
Steve Mangiameli

Reputation: 688

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.

Upvotes: 1

Related Questions