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 |
|
sqldba_ind
Starting Member
22 Posts |
 Posted - 2007-10-31 : 11:22:29
|
| Hi allI have Job which is scheduled and running "sp_expired_subscription_cleanup"to day I got failed"Executed as user: MYDOMAIN\sqladmin. ... publication 'Control_Center' has expired and has been dropped. [SQLSTATE 01000] (Message 14157) The subscription created by Subscriber 'SERVER1' to publication 'Control_Center' has expired and has been dropped"Please can body help reg in this issue.Thanks&RegardsSUSRI |
|
|
sqldba_ind
Starting Member
22 Posts |
Posted - 2007-10-31 : 15:18:41
|
| No body answered,My question was clear or any thing wrong with way of presentation.Thanks&RegardsSUSRI |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 15:25:37
|
| If you rerun the job, does it complete successfully?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sqldba_ind
Starting Member
22 Posts |
Posted - 2007-10-31 : 15:34:06
|
| No I did n't try for re-run.Thanks&RegardsSUSRI |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 15:36:15
|
| Well perhaps you should. Anytime I've gotten an error on that job, I've noticed it runs successfully the next time.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sqldba_ind
Starting Member
22 Posts |
Posted - 2007-10-31 : 15:39:33
|
| Ok tkizerthanking you very much.Thanks&RegardsSUSRI |
|
|
|
|
|
|
sp_expired_subscription_cleanup -- Error