Disabling of Scheduled Tasks

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric,

Using Install Shield, we are installing the Database (creating DB, Creating Sheduled Tasks, copying data etc) for our PB application. We are experiencing a peculiar problem in our customer's site i.e., When they backup the database (user DB alone) and restores them back, they find that the Scheduled Tasks are getting disabled.

Can you suggest me what are the possibilities that lead to this problem?

Your help would be highly appreciated.

Thanks. Kothans.

-- Anonymous, March 04, 1999

Answers

Kothans,

Is the msdb database out of space? This can happen when you run out of space in the msdb database. You may have to expand the msdb database and set the Task Engine Options to limit the future size. Use sp_spaceused to check.

Is there a sysbackuphistory table? Is there anything in the error log or Event Viewer about it?

Good luck,

Eric

-- Anonymous, March 05, 1999


Kothans,

I do not have any more insight into this problem except that the buzz is that SQL 6.0 task scheduler is buggy. If you are not at 6.5 consider upgrading. I even tried to delete a database (using my SQL 6.5) the task remained.

Sorry I can't find any more,

Eric

-- Anonymous, March 11, 1999


Moderation questions? read the FAQ