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.
| Author |
Topic |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2012-07-16 : 05:45:24
|
| I have a scheduled job.When it executes ssis pacages will execute.Apart from that it will call any system stored procedures or not? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 06:46:56
|
| Depends on what you mean.All jobs need system stored procedures to support them - why do you ask?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 07:09:35
|
| I asked whether it is compulsory or optional? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 07:44:03
|
| Is what compulsory?What is your issue/concern.It is compulsory to involve system processes - (stored procedures and other resources) when executing a job.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 07:47:25
|
| Yes.is it compulsory to involve sytem stored procedures when we are creating a scheduled job?How can i know what system stored procedures are called when a scheduled job is executing? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-16 : 09:18:42
|
| Try using the profiler.There are also a lot involved with running the scheduler itself and clearing up afterwards - you could say that they are needed to run the job too.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 09:51:38
|
quote:
Originally posted by sravanim
Yes.is it compulsory to involve sytem stored procedures when we are creating a scheduled job?How can i know what system stored procedures are called when a scheduled job is executing?
internally its compulsory. But you can either do it progrmatically using system stored procedures like sp_add_job,sp_add_jobstep etcif you dont want to do it programatically, you can even use the wizard available in SQL Server management studio to create job. Internally it calls the same above procedures to create job,steps, schedule etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 09:52:29
|
| for getting scripts you can create job using wizard and then use script job as option from SSMS to get involved scripts------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
scheduled job