Viewing 15 posts - 1 through 15 (of 167 total)
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...
June 3, 2022 at 1:52 pm
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 =...
May 20, 2022 at 9:01 pm
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...
May 20, 2022 at 6:40 pm
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...
May 20, 2022 at 4:36 pm
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...
May 17, 2022 at 3:41 pm
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...
May 16, 2022 at 10:02 pm
Cant use those PS features, not allowed to install on servers
May 16, 2022 at 4:39 pm
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...
May 13, 2022 at 8:51 pm
I am trying to get the hours difference.
July 21, 2020 at 6:08 pm
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...
June 8, 2020 at 10:11 pm
I've attached a screen shot of the table definitions.
June 8, 2020 at 9:42 pm
The report is displaying the data like this. see attached..sorry
June 8, 2020 at 9:33 pm
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...
June 8, 2020 at 9:23 pm
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.
June 8, 2020 at 9:14 pm
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
June 8, 2020 at 9:08 pm
Viewing 15 posts - 1 through 15 (of 167 total)