Need advice

I would like to do the following:
I don=B4t want to run SQL Jobs on my sql server. I will be using an application called ITO. This application will have a user assigned to it and will execute the jobs and monitor it (TNG Style). Anyways this is the problem:
To execute "exec sp_start_job @.job_name", the user must be the owner of the job.
Now lets say your job is an sql query. It has (for example) deletes. This user will need priviledges to be able to execute those queries.
The problem with this is that this application executes the job through a batch:
it lauches the batch file which contains the commands necessary: isql -S servname -U username -P password -
i "inputfile".
The problem is that a user=B4s account (that has priviledges) and its password is out in the open. Is there anyway i can go arround this. Any other command that can execute the job and dont need priviledges. I was thinking about SETUSER but for SETUSER you need to be sysadmin.
Does anyone have any idea?
:)Not sure Im following. But in isql -E means use a trusted connection so if your using Windows authentication you wont need to specify the user/ password. Does this help?
>--Original Message--
>I would like to do the following:
>I don=B4t want to run SQL Jobs on my sql server. I will be >using an application called ITO. This application will >have a user assigned to it and will execute the jobs and >monitor it (TNG Style). Anyways this is the problem:
>To execute "exec sp_start_job @.job_name", the user must be >the owner of the job. >Now lets say your job is an sql query. It has (for >example) deletes. This user will need priviledges to be >able to execute those queries. >The problem with this is that this application executes >the job through a batch:
>it lauches the batch file which contains the commands >necessary: isql -S servname -U username -P password -
>i "inputfile".
>The problem is that a user=B4s account (that has >priviledges) and its password is out in the open. Is there >anyway i can go arround this. Any other command that can >execute the job and dont need priviledges. I was thinking >about SETUSER but for SETUSER you need to be sysadmin.
>Does anyone have any idea?
>:)
>.
>