Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-03-03 : 09:54:39
|
| I have a job that runs every 20 minutes to do a tlog backup. Whenever I stop my sql server and start again I notice the job comes back saying Date and time are not avaialble in the jobs listed. I have to enable the schedule of the job EM>Managaement>SQL Agent>Jobs. How can this be resolved. Don't ask why the server is stopped. I have no control over that just now.All help appreciated. |
|
|
sphadke
Yak Posting Veteran
55 Posts |
Posted - 2004-03-03 : 10:03:54
|
| Did you create this job via the Wizard or using T-SQL? If you want this running every 20 mins go to EM->Server->Management->Jobs-> when you create or edit your job go to the schedules tab -> Recurring -> and you can configure it that way.. If not I think there would be a date/time issue on the target server.Sachin |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-03 : 10:14:16
|
| wizard if it is u mean from right-clicking and saying new job.I did all that recurring stuff already. It works fine once started and all. But once the server stops the enable on the schedule tab(when editing a schedule) becomes unchecked.All help appreciated. |
|
|
|
sphadke
Yak Posting Veteran
55 Posts |
Posted - 2004-03-03 : 10:42:41
|
| Another thing you might want to look into is the SQL Server Error Log.. Does it say any thing about the agent / jobs failing?Sachin |
|
|
|
sphadke
Yak Posting Veteran
55 Posts |
Posted - 2004-03-03 : 11:05:34
|
| here is another thing you can dorun the sp_help_jobhistory proc as soon as SQL Server starts and check to see if your job is enabled.. if it isn't you can run sp_update_jobschedule to enable the job. (simple enough?)Sachin |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-03 : 15:41:51
|
| This will not help as when the sql server is stopped it will happen again. I want to avoid the change happening.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-03 : 15:54:39
|
| Check out sp_procoption. This allows stored procedures to execute upon startup of SQL Server. Create your own stored procedure that does what you need, then run sp_procoption to change the option of startup.To figure out why the problem is happening, run SQL Profiler.Tara |
|
|
|
|
|
|
Unavailability of schedule