Why my job is failing when i schedule in SQL Server , Management , Jobs?
Posted on 2006-03-29
My name is Sridhar i got one problem to schedule job in SQL Server . Pls find details below.
We have Database Server called "A" and I registered that Database in my local machine (Enterprise Manager) by using Windows Authentication. I created a table called "mytable" and it shows owner as "Sridhar". Now I created DTS package in that connection task i have mention Windows Authentication and given Server name and selected Database ( you know that password is not necessory for windows authentication users). Now I scheduled that as a Job and I went to job and ran that job. But it is throwing Failed message. When I see "View Job History" then I see below line
*** The job failed. The Job was invoked by User MNAPOOL\Sridhar. The last step to run was step 1 (dtsBusinessDays) ***
In this case i went to login to see what kind of permissions i have. I clicked on my login properties and in that if i went to "Database Access", I see these permission are tick marked for a particular database "public","db_owner","db_datareader","db_datawriter".
I desperately need help in this..need help..help..help
Thanks in advance