What needed to create a job in SQL Server 2005
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?