Hi, all experts,
I am a database user not sa, I have SQLAgentUserRole permission, I need to create a job to read data from text file and store these data in DB. I try to create a job but get something like "Execute
permission was denied...........".

I did almost whole day study from goole, cannot get any help.
Can anybody tell me in details about the following two questiong:
1: What else needed to create a job, except SQLAgentUserRole permission, any setting in system, master, msdb.....

2: From where I can add my source codes to the job?

Thanks!

Andraw

Excuse me, why nobody can answer my question??????????

Hello, is somebody there?
I have a text file inside it each row has 65 data delimited by tab, there is no array and split function in stored procedure, what is the best way to parse this file?

haha...guess no one familiar wid ur question...if u giv me somtime i will answer...gud luck..am readin this stuff now..i am gud wid oracle..

mohammed