help with jobs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

help with jobs

hi there my job cant execute and send me this error thejob failed,the job was invoke by user jobs.the last step to run was step 1 unable to start execution of step, could get no proxy data from proxy_id im so frustrated and i wuill be veru grateful with any help hector [xx(]
What kind of job it is? Is it running ssis packages?
Did you create any proxy accounts?
MohammedU.
Moderator
SQL-Server-Performance.com
yes, im trying to run a dts, and i have my proxy account
thanks
Run the following and see your proxy setting are correct… select * from sys.credentials
select * from msdb..sysproxies
select * from msdb..sysproxylogin
select * from msdb..sysproxysubsystem
Read the following blog…
http://chopeen.blogspot.com/2006_06_01_archive.html http://msdn2.microsoft.com/en-us/library/ms139805.aspx
MohammedU.
Moderator
SQL-Server-Performance.com
thanks im going to check
thanks a lot
]]>