So is this possible

set @execSrvQuery = (

select top(1) Replace(d.SQLServerName+'\'+ s.SQLInstanceName+','+Convert(varchar(10),TCPPortNum),',0',',1113') as SQLInstanceName

FROM Catalog.eAudit.DatabaseServerSQLInstance s

inner join [Catalog].[eAudit].[DatabaseServer] d on d.DatabaseServerID=s.DatabaseServerID

where s.SQLInstanceName like '%KCW%' )--and s.SQLInstanceName not like '%SSAS%'

union

Select @@ServerName)

EXEC [@execSrvQuery].[msdb].dbo.sp_update_job @job_name...

Here is what I changed it to, but still getting that error.

USE MSDB;

GO

DECLARE @job_name nvarchar(max)

DECLARE @enable int

create table #JobsToDisableEnable

(

job_name nvarchar(max),

enable int

)

DECLARE @Query varchar(1000)

SET @Query ='BULK INSERT #JobsToDisableEnable FROM "G:\SQL_Jobs\DisableEnableJobs\joblist.txt"

WITH(

ROWTERMINATOR =...

I noticed that it is using the value from sp_update_job, how would i get it to use the values in the FROM #JobsToDisableEnable? Like its doing enabling all and disabling...

• This reply was modified 1 year, 11 months ago by  cbrammer1219.

Here's what I have come up with, but I get an error.

Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 25 [Batch Start Line 2]

Supply either @job_id or...

It is manual, so when deployments are done, I would run it to disable them, then once deployment is done, I would run it to re-enable those disabled jobs in...

I wish I could use a table but can't create tables on the servers, I have to read the Job name from a text file, which the jobs are the...

Cant use those PS features, not allowed to install on servers

I see that one but need to put the names of jobs in a text file, cause that will enable and disable all jobs, some jobs I don't want to...

I am trying to get the hours difference.

When I use your code I get errors all over , states sum function requires 1 arg, and doesn't recognize OBSERV_DATE, yes I figured to let the report do the...

I've attached a screen shot of the table definitions.

The report is displaying the data like this. see attached..sorry

So to get it to show them day 1 of each month, totals and day 2, day 3 do I need to group by something special within the report? because...

The data returned doesn't look sum it properly from what I am seeing in the data, for example oct, nov dec, jan isn't showing data as in the attachment.

We don't have a table for dates, this is a poorly designed database. I have to figure the fiscal year based off observ_date it goes oct through sept