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 |
|
Herleen Kaur
Starting Member
3 Posts |
 Posted - 2010-12-22 : 08:03:27
|
| Hello everybody,I've restored a backup with different database name, now I'm unable to execute jobs, I've checked the code of all of them, which contains new database name. Still I'm not getting requisite output.Can anybody help me out of this.Thanks and regards,Herleen Kaur |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-22 : 09:34:22
|
Whats the method you have used for restoring the database.Is the new database visible ?quote:
I'm unable to execute jobs, I've checked the code of all of them,
Are you getting any error ? |
 |
|
|
Herleen Kaur
Starting Member
3 Posts |
Posted - 2010-12-23 : 01:20:00
|
| Yes the database is visible, and I can perform all else queries on it. Except requisite JOB execution, i.e. JOBs are being executed on scheduled time, but the changes which are expected i.e. I wanted to insert into some tables in the new database and wanted to perform some related updates post insertion. Which I'm unable to find. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-23 : 01:27:33
|
| What error message are you getting? |
|
|
|
|
|
|
JOB after Restore