SQL SERVER Agent Problem?

[bmann]

I have mapped a network drive on my server. The administrator gave me full rights to the directory. When I go to my DTS package and run the package everything works OK. But when I scheduled the Package as a Job it fails. I am getting the following error:

Error string: The Microsoft Jet database engine cannot open the file 'F:\FPD_12-15-2002.MDB'. It is already opened exclusively by another user, or you need permission to view its data.

I need someone's help to solve this problem.

 

[anilcognos]

Check if a file called FPD_12-15-2002.lDB'
exists. If so delete that and try.
Also check under whose account the Job is running

 

[Corran007]

I would say its permissions error. When you run a job, it runs under the user permisions of the sql agent. When you manually run the job, it is run under your permissions Unless you changed it from defualt, the agent only is able to do things on that particular machine since it utualizes local acccount. You will need to set it up with a domain account configured with proper permisions to run it. If you do not have a domain, make sure a user is set up on both machines to run it from with the proper permissions..

Hope this helps

 

[tlbroadbent]

Check out the following link.

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269074

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[bmann]

Thanks for everyone's help. I am checking all the permissions. Also, I need to perform a command line for mapping drive in a SQL task. Have a good day.

Brian

 

[tlbroadbent]

Don't map a drive. Use the UNC.

\\servername\sharename\path\filename.ext Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[bmann]

thanks tlbroadbent.