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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2004-08-10 : 01:53:46
|
| Hi,I'd like to know if someone knows how to start a replication agent in a sql job?thanks.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-10 : 12:46:16
|
| The replication agent should already have a job, so then just sp_start_job.Maybe I misunderstood the question.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-10 : 22:27:57
|
| Thanks Tara, just saw the job last night. If the replication fails, I'lll just create an alert and start the job right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-11 : 12:03:39
|
| You can setup notifications on the job so that it does something when a failure occurs. You will need to setup operators though for this. We page ourselves on the important failed jobs. Then whoever is on-duty "dials in" and corrects the problem.Tara |
|
|
|
|
|
|
Agent Fails, Run a Job