I am getting errors on just a few of my shared schedules for SQL Server Reporting Services. I can not figure out why some shared schedules are giving this error and why others are not. All in the properies on SQL Reporting Services Shared Schedule seem the same. All in SQL Server Database ReportServer seem to be the same. And all in SQL Server Jobs seem to be the same when I compare the two jobs.
This is my error:
MSWinEventLog 1 Security 52473 Thu Jan 20 07:10:04 2011 531 Security SYSTEM User Failure Audit <ServerName> Logon/Logoff Logon Failure: Reason: Account currently disabled User Name: Domain: Logon Type: 3 Logon Process: Authz Authentication Package: Kerberos Workstation Name: <MyServerName> Caller User Name: <MyUserName> Caller Domain: INSITE Caller Logon ID: (0x0,0x1B8D4) Caller Process ID: 484 Transited Services: - Source Network Address: - Source Port: - 52471
From my testing I can tell the error is coming from Job:
'83086371-F206-4727-B693-DFF295A10C8E'
Below is code I used to figure out what Shared Schedule this is for.
Any more help on things to look at to find out why get login error is greatly appreciated.
;WITH cte (job_id, job_name, execution_time, execution_order)
AS
(
SELECT DISTINCT j.job_id
,j.name
,CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':'))
,ROW_NUMBER() OVER (PARTITION BY j.job_id ORDER BY CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':')) DESC)
FROM msdb.dbo.sysjobs j (nolock)
INNER JOIN msdb.dbo.syscategories c ON j.category_id = c.category_id
LEFT OUTER JOIN msdb.dbo.sysjobhistory jh (nolock) ON j.job_id = jh.job_id
WHERE c.name ='Report Server'
)
SELECT
x.job_name
,c.name
,x.execution_time
,c.path
,su.description
,CONVERT(varchar(max), su.ExtensionSettings) as ExtensionSettings
,sc.EventType
,sc.Name as ScheduleName
,'EXEC msdb..sp_start_job ''' + x.job_name + '''' as SQLStatement
FROM cte x
INNER JOIN dbo.Schedule sc ON x.job_name = CONVERT(varchar(100), sc.ScheduleID)
INNER JOIN dbo.ReportSchedule rs ON sc.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Subscriptions su ON rs.SubscriptionID = su.SubscriptionID
INNER JOIN dbo.Catalog c ON su.Report_OID = c.ItemID
WHERE execution_order = 1
--AND sc.Name = 'Daily - Morning'
and sc.Name = 'Monthly - 20th - Morning'
--and x.job_name = '83086371-F206-4727-B693-DFF295A10C8E'
ORDER BY 4, 2
This is my error:
MSWinEventLog 1 Security 52473 Thu Jan 20 07:10:04 2011 531 Security SYSTEM User Failure Audit <ServerName> Logon/Logoff Logon Failure: Reason: Account currently disabled User Name: Domain: Logon Type: 3 Logon Process: Authz Authentication Package: Kerberos Workstation Name: <MyServerName> Caller User Name: <MyUserName> Caller Domain: INSITE Caller Logon ID: (0x0,0x1B8D4) Caller Process ID: 484 Transited Services: - Source Network Address: - Source Port: - 52471
From my testing I can tell the error is coming from Job:
'83086371-F206-4727-B693-DFF295A10C8E'
Below is code I used to figure out what Shared Schedule this is for.
Any more help on things to look at to find out why get login error is greatly appreciated.
;WITH cte (job_id, job_name, execution_time, execution_order)
AS
(
SELECT DISTINCT j.job_id
,j.name
,CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':'))
,ROW_NUMBER() OVER (PARTITION BY j.job_id ORDER BY CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':')) DESC)
FROM msdb.dbo.sysjobs j (nolock)
INNER JOIN msdb.dbo.syscategories c ON j.category_id = c.category_id
LEFT OUTER JOIN msdb.dbo.sysjobhistory jh (nolock) ON j.job_id = jh.job_id
WHERE c.name ='Report Server'
)
SELECT
x.job_name
,c.name
,x.execution_time
,c.path
,su.description
,CONVERT(varchar(max), su.ExtensionSettings) as ExtensionSettings
,sc.EventType
,sc.Name as ScheduleName
,'EXEC msdb..sp_start_job ''' + x.job_name + '''' as SQLStatement
FROM cte x
INNER JOIN dbo.Schedule sc ON x.job_name = CONVERT(varchar(100), sc.ScheduleID)
INNER JOIN dbo.ReportSchedule rs ON sc.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Subscriptions su ON rs.SubscriptionID = su.SubscriptionID
INNER JOIN dbo.Catalog c ON su.Report_OID = c.ItemID
WHERE execution_order = 1
--AND sc.Name = 'Daily - Morning'
and sc.Name = 'Monthly - 20th - Morning'
--and x.job_name = '83086371-F206-4727-B693-DFF295A10C8E'
ORDER BY 4, 2