SQL Server Job

  • 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?

  • 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

  • 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