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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-01 : 13:05:31
|
| Jobs are copied from sourse server to DR server.Can we modify the jobs in DR server? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-01 : 14:01:29
|
if they are copied for the source server to the DR Server, why would you need to? The point of a DR server is to be identical to the source/production server. Assuming by DR you mean Disaster Recovery..
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-01 : 15:14:18
|
| DR server job is not enabled still it is running because it is originated from source/prod server. A user is effecting from this.How would i fix this.....I need to change sysjobs coloumn in MSDB on DR server properties ?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 00:03:11
|
| No, you can edit job in em or ssms. Should have your dba to do this. |
|
|
|
|
|
|
job