Hi Chris,

FYI, I need to change my initial question to this.

1) Job A (8 am start)

2) Job B-start once Job A completed (until 11:59pm)

Means that, the 1st execution time of...

I really appreciate if somebody can provide me with some advice about my question.

Appreciate if somebody can advice me.

Thanks and regards,

Golden

Hi Chris

As in your reply, we need to stop Job B by creating Job C since it is bound to the completion of Job A.

If I would like to set...

Hi chris.schau,

Thanks again for your opinion.

It means that if the if Job B is bound to the completion of Job A, even we set the schedule inside job B, will...

Hi LK,

Thanks a lot for the sharing.

Aside to chris.schau & dba_pkashyap,

Thanks a alot to the information as well.

Best Regards,

Golden

Sorry,

Mistake from me.

Anyhow,

If two jobs are set, then how about the starting time of the 2nd job since it is triggered by 1st job?

Regards,

Golden

Hi

Thanks a lot for the information details.

Can you give me some advice for this design?

1 job contain 3 steps:

***(schedule to start at every 8am daily...

Thanks for the comment.

I need more comment from you guys

Thanks

homebrew01 (7/20/2009)

---

We had done a large data purge recently and I finally had an opportunity to shrink a data file to reclaim some much needed space, by running DBCC SHRINKFILE...