Loack during dimension processing

Hello!

I recieve the following error message when processing dimensions in a scheduled dts package:

Description: Processing within a transaction
Step Error code: 80040024
Step Error Help File:
Step Error Help Context ID:1000440

To me it seems like the dimensions are locked by another task, probably a cube processing.
The strange thing is that I have dependencies in my dts package, so that the cube processing shouldn't start until the dimensions are processed and every dimension comes from different tables.

Anyone with similar problems? Any suggestions for further error searching?

Grateful for every info!Can you run the dts interactively?|||Yes, never any problem with that...

Listing all scheduled tasks on a server

I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

ThanksOriginally posted by FunkyD
I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

Thanks

Fixed it - forgot that you have to run against MSDB...lol