DSXchange

I build a job. In its "after-job subroutine" I write down the DOS command:
"copy d:\userquery.mdb \\suzs004a\enduserquery\userquery.mdb /y"
to copy a file to another network folder. I'm sure the login user have the full control right to that folder.

when I run it directly. It's Ok. But when this job run from schedule. It will show an error to say have no rights to \\suzs004a\enduserquery folder.

Why? Does it means Director use an other user to run the job when use Schedule?

Is there any body know about it ?

thanks

It isn't a director bug, but the way in which windows assigns permissions to the remote folder or even maps that folder. To check that, just change your copy command to use a local folder and you'll see that runs OK from a job.
Are you using the same userid when running the DS job?

Or check if you are using different user id to run and a different one to Schedule.

Thank you.
I run this JOb when I login as administrator, I also run schedule it at the same user as administrator. but the result is I can run this job, but schedule cannot. does it means Director schedule will use another user to start the job?

You can find userid that been used for the job run from the log. If you double click on any of the event, it will show you the user.

Check the Schedule tab in Administrator to verify whether or not you really do run under the same ID for scheduled jobs.

One possible reason could be the number of warnings to abort the job, in director, when you run a job the default number of warnings before the job is aborted is 50. however when you run the job through designer, there is no limit on the max number of warnings,

in this case if your job is producing a lot of warnins ( i.e., more than the default value set in director), it will not run through director but it will run through designer.

Hi -

Change the permission of the file that you are trying to copy. Sometimes this becomes an issue if you are running the job as a differnt user.

AK77

You can resolve this by giving the "administrator" user credentials in the Schedule tab in DataStage Administrator. If this is left blank, permissions of Windows system scheduler are used by Scheduler to copy files. And hence the error message because of insufficient permissions for the system user on your NT network drive