
September 15th, 2004, 09:38 PM
|
|
Registered User
|
|
Join Date: Apr 2003
Location: Denver
Posts: 29
Time spent in forums: 1 h 37 m 25 sec
Reputation Power: 0
|
|
|
SQL Server Job doesn't run
Hello,
I'm just trying to set-up and incredibly simple Job in SQL Server and it doesn't appear to be running. I created a user who has owner/public permissions on the database I want to run the job on. I selected the correct database from the dropdown, created a simple step that simply inserts a record into a table. I scheduled the job to run once at a time a few minutes ahead of my system clock and for notifications the job should write to the app log regardless of the outcome.
The job is listed as enabled, runnable, and scheduled but after the time has elapsed there is neither a record in the specified table or an entry in the even log. It would appear that the job never even tried to run. Any ideas why this might be the case?
Cheers,
Tripp
|