Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Batch Processing

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-02 : 08:20:14
Shafiq writes "I was working previously with AS400 environment Where user can select some paramters and submit the job (to run in background).

How can I achive the same in SQL 2K5, I need to download data from AS400 but I don't want to run this interactively. I want the user to select there parameters (from ASP.NET page) and submit the job in batch in SQL2K5. Job will take those parameters and start extracting the data as batch job.
SQL jobs can't be run by a simple Domain User as they require some additional previllages.
Please Guide.
Thanks
Shafiq"
   

- Advertisement -