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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-30 : 09:04:58
|
| Monika writes "HiI have created a SQL Job. I want to execute a Stored Procedure using this job.But Stored Procedure needs an Input Parameter(DateTime Parameter based on which data is to be deleted).Can it be possible to execute this type of Stored Procedure using SQL Job or Is there any method to resolve this issueThanksMonika Sharma" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-30 : 09:09:21
|
| You can modify the stored procedure to read the data from a table, and create a process to insert the parameter's value into that table before the job runs. The job would read the table, and do nothing if there is no data in it. The job should also have a step to clear out that table once it completes successfully. |
 |
|
|
|
|
|
SQL Job can accept Input Parameter