Thanks for the tip. My failure to observed that simple feature cause some additional programming.. I reworked the call and removed some superfluous code. Thanks again.

What I did was just simply add a second step, controlled by a pass parameter to delete the entire job.

Looking at the syntax for sp_add_job I can see that. ...

Here is a little side note that I'd like to share with you. First some more background. Since the jobs that I'm creating on the fly are only...

How about creating a new temporary table with the proper PK constraint then load it from the production table. When it gets loaded simply rename the production one to...

I didn't. The job has been running for almost 1 week. Time to move on to other projects.

Thanks for your help. I am glad that I've got the process to work and I was able to squeeze a proces that would have taken 24 hrs to...

I'm guessing you are missing the point of my original issue. There is no major problem. Some background....

I started with a stored procedure that ran single-threaded. A...

The Master job & agent jobs run under the same domain sysadmin account.

1) yes. The master job starts all spawned jobs and all of the spawned jobs do run successfully.

2) The spawned jobs run under the same account as the master...

This is a very common problem and one has to be very careful how the SQLAgent is configured. I saw this issue when I was trying to create a...

This was a big help... especially going into detach mode to drop the attached user. Thanks.

Not really knowing all of the specs to your application but for what reason are you storing the image as a blob in the DB? Is it a security...

I do a fair amount of work with very large tables that have schema bound views. There is a fine line/balance to decide if the view could be used....

Don't get me wrong.... DTA is not a panacea but in a situation where a very complex query is involved it is worth waiting the time having DTA do it's...

Does anyone use DTA to see what SQL Server wants to do for additional indexes / statistics? I use this along with viewing the execution plan to address performance...