Sue, sorry but you have misunderstood me again. You are referring to SUBSCRIPTION parameters, I am referring to REPORT parameters which are stored in the report, as I can see...

Sue, you misunderstood me, I did not mean that the subscriptions are stored in the report, I meant that I believe the following are in the user-defined report:
* user-defined...

Sue - They are not data-driven subscriptions but subscriptions for a user-defined report with user-defined report parameters, which are all stored in the report file itself (myreport.rdl), not the database.

No I don't believe so. Although there should be an easier/quicker way to creating many subscriptions for the one parameterised report.

bump

Anyone please?

This may help too, per http://www.sqlservercentral.com/Forums/FindPost829648.aspx 🙂

-- link sysprocesses to sysjobs and sysjobsteps

select

p.spid,

p.program_name,

j.job_id,

job_name = coalesce(j.[name], ''),

jobstep_id = coalesce(js.[step_id], ''),

jobstep_name = coalesce(js.[step_name], '')

from master.dbo.sysprocesses p

--left outer join msdb.dbo.sysjobs j on...

Here it is 🙂

--===== If test table exists, drop it

IF OBJECT_ID('TempDB..PublicHols','U') IS NOT NULL

DROP TABLE PublicHols

--===== Create test table

CREATE TABLE PublicHols

...

No problem thnx for the posting tip, good idea, I'll do that shortly...

however got this answer from another forum & it works perfectly. . 🙂

select dateadd(dd, n.number, h.StartDate)

from master..spt_values...

BUMP.... anyone?

Just trying to get this (job monitoring) script to work for SQL Server 2000.

This works except for the 'LastQuery'.

Is there a way to get the ::fn_get_sql (SQL Server 2000) to...

Thanks for the info Seth...

Managed to get it to work by slightly changing the 'sysjobs' join only. 🙂

Failing code was:

left outer join msdb.dbo.sysjobs j

on substring(p.program_name,32,32)...

Awesome thanks, I was having the problem too & just noticed 'msdb' properties were not set to 'auto shrink' & grow was set to 1Mb, so I turned on autoshrink...

Ok taa, but how please?

* In the TSQL code (xp_cmdshell('...dtsrun...')

but it never gets past the xp_cmdshell in the code as that's what hangs.

* in the DTS itself somehow?

* in...

So basically you just commented out the 2nd part of the join as follows:

left outer join msdb.dbo.sysjobsteps js on j.job_id = js.job_id...