Hi,
I created a scheduled job in sql server 2005 which takes a daily backup of database.
My problem is this job does not run automatically.but when i execute it manually it runs on that instance.
do i need to activate any servrice to have scheduling of jobs running perfectly on my machine ?
Please guide me on this.
Thanks,
Prashant
The SQL Agent Server must be running (Check in Services) and have OS permission to the backup file location.
The Job must be 'Enabled'.
The Schedule must be 'Enabled'
No comments:
Post a Comment