Look up sp_send_dbmail. It shows examples of how you can put your query in the @QUERY variable.

"... the ways you says will just send me an email that the job...

Hmmmm ... off the top of my head:

1) Put the query above into a job "Restore status", using sp_send_dbmail to send you the results of the query

2) Schedule it...

Sturev (4/2/2011)

---

I have a need to pull a date column from one table based on the date in another.

Example:

I have a service table that contains details about a service appointment

Then...

There are many ways, but I think more information would be useful. Are your replicated databases A nd B publishers or subscribers ?

Are you wanting to copy a few tables...

On the top menu bar of the maint plan there's an icon for "Reporting & Logging" . Is that what you want ?

does a simple

select * from EMP_VIEW_DB3 work ?

I think if you ask a precise question, you might get a precise answer.

I did a search on the error message and see a variety of causes. Perhaps you could give more details about your environment. What causes have you ruled out ?

Grant Fritchey (3/31/2011)

---

Krasavita (3/31/2011)

---

I am sorry, I didn't right this code and I don't know which statment is causing a problem, I will re write the statment after I find...

Krasavita (3/30/2011)

---

I resolved the problem,but not sure for 100%

I ran update statment 2 hours on that table (I thought update was complited) in the query analyzer and tryed to close...

You could add a datetime column with a default of getdate for future use. That would show you when it was added, but not when it was modified. You'd need...

I use shareware SQLScheduler for Express

If a database is in FULL recovery, and you are taking t-log backups, there's not really a good reason to only take them every hour, or 3 hours. Just change...

There's your answer .... Every 15-20 minutes for us.

Side comment ... Why aren't you on SP3 ?

Any time someone is on an old version, it raises the question of if their problem would be fixed by being on...