Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

shared schedule disabled login

Status
Not open for further replies.

katekis

MIS
Feb 12, 2009
66
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top