July 3, 2012 at 3:21 am
i am facing the problem with SQL Job
we have SQL Job, that internally calls Storer procedure and inthis stored procedure calls batch script also
the issues was coming job, job status is showing as "executing" when shceduled run
but reports generating and every thing is fine. (if i killed this job with kill command, after that this process
is showing killed/Rollback in SP_WHO2.
when i ran the job manually, job status is showing as "Succeeded".
How can i fix this issue, can anyone give me suggents?
July 3, 2012 at 7:01 am
Not really sure what you are asking. Can you be a little more clear?
Have you reviewed the permissions of the job? How are you trying to do the import? Does the owner of the job have the correct permissions?
Fraggle
July 5, 2012 at 3:34 am
once completed job execution, even throuugh job statu is showing "Executing" (when job shceduled Ran).
if start job manually, job execution is fine and job status is shlowing "Succeeded"
also for the job i have given domain admin rights user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply